Another way to manually add a table of contents in Excel is by using the Hyperlink Function. In this method, you need to type all the names of your sheets and add hyperlink formulas to each one ...

This guide will take you through the process, showing you how to build a navigation dashboard in Excel using dynamic hyperlinks from scratch.

How to create an automated list of worksheet names in Excel -- and add a table of contents.