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

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

To create a new sheet, right-click on any existing worksheet name and click on "Insert," then select "Worksheet." Alternatively, you can press Shift+Alt+F1.

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

Now, let’s create a dropdown on another sheet named Dropdown and reference Animals_List : Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet).