You can automatically create a table of contents using Excel's Power Query tool ... and inserting a hyperlink. To add the VBA code, you need the Developer tab. If you've not accessed it before ...