Create the list of worksheets with Hyperlinks (Table of Contents)
Sub CreateTableOfContents() Dim x As Long ThisWorkbook.Sheets.Add Before:=ThisWorkbook.Worksheets(1) ActiveSheet.Name = "Table Of Contents" For x = 1 To Sheets.Count ActiveSheet.Cells(x, 1).Select ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(x, 1), Address:="",SubAddress:="'" & Sheets(x).Name & "'!A1", TextToDisplay:=Sheets(x).Name Next x End Sub