Tab Index with Description

[weaselmcguff]

I have a sheet that goes out and displays all the Tabs in the workbook and listed them in column A. Is there a way to place in Column B what that "tab" spreadsheet is in that workbook?

Example

A B
DOC-PCS12 Training Doc for PCS1.2
TRV-CARRIER Traveler for Carriers
DOC-CARRIER List of Carriers


It pulls Column A automatically want to be able to associate a description to it. Is there anyway to have the description stored somewhere on the sheet but not in the columns or rows?

Any help is appreciated
Thanks

 

[shg]

You could create a named constant on each worksheet (Formulas > Name Manager > New ...) with a description, and reference that in a formula in col B.