With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...
You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.