Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

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

When working with Excel files that have different sheet names or layouts, Power Query can dynamically detect and extract the necessary data.