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

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