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

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.

However, when you have a multi-sheet workbook encompassing lots of data, you may want to create a summary sheet to extract data from an Excel workbook.

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

In Excel 2013 Home Menu, select Blank workbook. Sheet title and custom date In cell A1, type January 2014. Excel changes the format to Jan-14.