Excel create an Index on the first sheet with links to subsequent sheets

Question

There are 12 worksheets in my workbook. The index is on the first worksheet, while the data for the index is on the other eleven sheets. This Workbook makes reference to a file tree structure, and my goal is to connect each Folder name to the appropriate Worksheet. These folders have names like "Folder 1, Folder 2," etc. Actually, each folder name is distinct.

The table below is the folder tree.

I need to name the worksheets based on their breadcrumbs. So For example Folder 3 Would be

Folder 1>Folder 2>Folder 3

With the limit being set as 31 characters, Any directories 6 deep with long names wouldn't fit. So I have the table below.

How do I approach this? The worksheets are in the correct order; all I need to do is link to the first table and batch rename them based on their paths so that when users click on Folder 8, they will see tabs F1.F6.F8.

Answer 1

Below example shows how to use the Hyperlink function in excel to take a value from a cell (your worksheet name column) and use this to link to another tab.

=HYPERLINK(CONCATENATE("#", [cellcontainingthetabname], "!A1"), [textyouwishtodisplay])