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.