Jumping to a Specific Worksheet

My Excel Toolbox includes the following dynamic array function:
=ListSheets([SkipHidden])
This function returns one row with sheet names in subsequent columns. To return the list in one column with several rows, use this:
=TRANSPOSE(ListSheets([SkipHidden]))
In older versions of Excel that do not support dynamic arrays, you can use ListSheets with the SpillArray function like this:
=SpillArray(TRANSPOSE(ListSheets([SkipHidden])))
SpillArray will determine and populate the spill range for its array expression argument, simulating a dynamic array.
After populating a column with sheet names, you can create a hyperlink to each sheet by adding a formula to the next column; however, there are certain issues when a hyperlink is created using the HYPERLINK function:
+ A hyperlink cannot reference a worksheet without identifying a cell, range, or name on that sheet
+ Activating such a hyperlink will change the worksheet’s previously selected cell or range
+ A hyperlink cannot reference a chart sheet because a chart sheet has no cells
+ A hyperlink referencing a hidden sheet will fail silently when activated
These issues are resolved by the following My Excel Toolbox function:
=SheetNameLink(Sheet_Name, [Friendly_Name], [Screen_Tip])
where Sheet_Name is like [file]'sheet' or [file]#'sheet' or 'sheet' or #'sheet'. For example, if cells A1:A20 contain a list of sheets created by the ListSheets function described above, this formula in cell B2 would create a hyperlink to the worksheet or chart sheet listed in cell A2:
=SheetNameLink(A2)
The hyperlink does not address a cell; therefore, the sheet's previous selection is not altered.
My Excel Toolbox also includes the following function:
=SheetListUpdateLink([Friendly_Name],[Screen_Tip])
This function uses SuperLink to create a hyperlink that will list a workbook's sheets (including hidden sheets) in subsequent rows. Each sheet in the list includes a hyperlink to hide or activate (unhide) the sheet.
Finally, My Excel Toolbox's SheetsDialog macro displays a sheet activation list at the bottom-left corner of Excel's window (similar to right-clicking a scroll button at the left side of sheet tabs). Here is an abbreviated version:

Sub SheetsDialog()
    Dim X, Y
    Const PxPerPt = 96 / 72
    With Application
        X = .Left * PxPerPt
        Y = (.Top + .Height) * PxPerPt
        .CommandBars("Workbook tabs").ShowPopup X, Y
    End With
End Sub

See https://sites.google.com/view/MyExcelToolbox/

And if you're going to create a TOC, putting a Home button on each page is a quick way to get to the TOC. Add a shape to another sheet. Add a link to the TOC. Copy the shape to all the other pages.