Streamline Your Workflow with Power Query Power Query provides a robust and flexible approach to combining and transforming data from multiple Excel sheets into a single, structured dataset.

This involves the extra (but straightforward) step of creating data connections between each table, before combining the queries in the Power Query Editor. 4 Excel Power Query Commands You Need to ...

With Power Query in Excel 365, you can do just that. This powerful tool allows you to merge files from a folder into a single dataset, automatically updating as new files are added.

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.