Is there a way to consolidate multiple spreadsheet files?

The answer is ‘NO’! You can consolidate multiple sheets from different Spreadsheet files also. To do that you should use the Google Sheets IMPORTRANGE function together with Query. That part I’m skipping now. I will try to write another Google Sheets tutorial for that. Otherwise, you will get confused.
For More Information Please Refer:

You May Also Like to Read: