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.