The sheet technique is interesting, but the real focus is exposing the workbook’s metadata using Power Query. SEE: Google Workspace vs. Microsoft 365: A side-by-side analysis w/checklist ...

How to Perform Multiple Queries on an Excel Spreadsheet. Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server.

TL;DR Key Takeaways : Power Query simplifies data consolidation by automating the process of combining Excel files with inconsistent sheet names, reducing errors and saving time.