Thanks Chuck!
--
Smitty
Somerset, PA

"CLR" wrote in message
...
See here

http://www.mvps.org/dmcritchie/excel/buildtoc.htm


Vaya con Dios,
Chuck, CABGx3




"Bill Smith" wrote:

Is there an automated way to create an Index worksheet for a large
workbook?
I inherited a bunch of workbooks with a different product on each
worksheet.
The only place the part number is listed is on the tab.
I'm part way thru manually creating a worksheet that lists the tab name
and
links to the individual worksheets. It's much too time consuming. Any
ideas
will be appreciated.
Thanks!
--
Smitty
Somerset, PA