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

Using Structured References in Excel Tables Excel tables offer a powerful feature called structured references, which allow you to create formulas that automatically expand and contract with your ...