Creating a List of Worksheet Tabs in a workbook as a "Contents Page"

CREATE A HYPERLINKED LIST OF SHEETS IN A WORKBOOK ON A FRONT SHEET
This macro creates a "table of contents" on a sheet at the beginning of the workbook. Each sheet listed is also an active Hyperlink so click the name will take you directly to the sheet. Put a link on all your other sheets back to this front sheet and you have an extremely fast navigation system for large workbooks. There's a sample file for you to see this operate.

Create Hyperlinked List of Sheets

Once the hyperlinks are created for you, you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.