Creating a list of worksheets

I can visualize situations where an auto-generated list of worksheets would be a helpful addition to many workbooks. A couple of ideas include tracking the progress of a workbook audit, eyeballing a simple list of all worksheets in a workbook, or maybe taking things up a level by building a clickable worksheet index. Such an index may feel redundant. After all, when right-click on the navigation arrows in the bottom left-hand corner of Excel you can navigate by double-clicking on any worksheet Name the Activate dialog box. On the other hand, this index will be a self-updating listing that includes the Names of hidden worksheets and can be sorted alphabetically if desired. Let’s jump in::

1. Open the Chapter 12 – Workbook Index.xlsx example workbook for this chapter, which contains 17 worksheets.
2. Activate the Summary tab so that your index will appear as the first sheet in the workbook.

Tip

When you load data from Power...