You might want to open two files in two separate windows to compare them. Also, if you want to edit two files simultaneously, you need to open them separately. That is why you can change Notepad ...

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.