Create a List of All Sheet Names | Dynamic Excel Table of Contents inc Hyperlinks & Auto Updates

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell