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

You can also access functions. How to use Name for quick access to common functions in Excel Excel’s Name box automatically lists common functions in the dropdown when you enter the equals sign.