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

Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

How to Perform Multiple Queries on an Excel Spreadsheet. Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server.