Learn how to combine Excel files with different sheet names using Power Query. Save time, reduce errors, and automate your data consolidation ...

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

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.