Download the featured file here: https://www.bluepecantraining.com/create-a-list-of-all-sheet-names-dynamic-excel-table-of-contents-inc-hyperlinks-auto-updates/

Table of Contents:

00:00 - Intro
00:55 - VBA Method
08:57 - GET.WORKBOOK METHOD

In this video I demonstrate how to create a list of worksheet names in Excel that you can use as a table of contents. I will show you how to add hyperlinks so that you can easily navigate inside your workbook. The worksheet list (or table of contents) will be dynamic, so if you add or delete sheets or change sheet names the table of contents will automatically update.

This video features two methods for creating a list of sheet names. The first method uses a VBA macro ( see above for a link to the code ) and the second uses an Excel 4.0 macro function called GET.WORKBOOK. VBA is more secure to use than the old Excel 4.0 macros, so if you are worried about security, use the VBA solution.
------------------------