If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.
The post How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata appeared first on TechRepublic.