Table of Contents based on worksheet names???

[Cactusfunk]

Hello,

Is it possible to generate a "table of contents" automatically based on the names of the non-hidden worksheets at the bottom of a workbook?

So if I had sheets 1-3 and 5 visible I would get a list on the first sheet like..

Master
DS0
DS1
BDFB

and if I made visible sheet 4 the list work automatically update to say..

Master
DS0
DS1
DS3
BDFB

Also if I had multiple sheets named the same thing it would sum the number of sheets..

Like

Master 1
DS0 12
DS1 8
DS3 10
BDFB 3

And if I change the order of sheets the table of contents would be up dated

Master 1
BDFB 3
DS3 10
DS0 12
DS1 8

The table of contents code would need to work in such a way that it would not use absolute paths as the workbook can be as small as 10 worksheets or over 100.

Thanks for reading

Jason

Oh and if this is beyond the scope of excel, please hit me over the head with a little reality

 

[Al Chara]

Try http://asap-utilities.com/
It has a lot of useful utilities including what you want.