I want to create a table of contents based not on the tab names, but instead the data in a specific cell (B1 - which is the same for all the sheets) as it contains a more detailed description of the sheet. The tab names are abbreviations which would be meaningless to most users.

So far I have found everything I need to create this table of contents except how to loop through all the sheets and get the description in B1 into the TOC.

Any advice appreciated.