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.

This is the demonstration file to accompany the article, How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata by Susan Harkins. From the hottest programming ...