Power Query is specifically designed to handle complex data consolidation tasks, even when working with files that have varying structures or inconsistent sheet names.

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

The Power Query technique is eerily similar to a similar malware distribution method detailed in 2017 by SensePost, which abused another Excel feature for importing data in Excel files, namely ...