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

On Jan. 23, 2007 the W3C granted Recommendation status to XQuery, the XML query language designed to do for Web services what SQL did for relational databases. XQuery allows you to work in one common ...

Developers can utilize the power and flexibility of XQuery in many development scenarios: Data integration -- for developers who need to process information from XML, relational and other data sources ...

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