You can even perform multiple queries to connect to several sources and create a custom worksheet with all of the information you need.

Using Structured References in Excel Tables Excel tables offer a powerful feature called structured references, which allow you to create formulas that automatically expand and contract with your ...

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