There is vba code here, by David McRitchie, if you want to do it yourself...
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
-0r-
you could find the XL Extras add-in at my website and give it a try...
http://www.realezsites.com/bus/primitivesoftware
(it also sorts sheets and does other stuff)
--
Jim Cone
San Francisco, USA



"Sam"
wrote in message
Hi!
I've a workbook with over 40 worksheets, and would like to create a
list(index) on the first worksheet, so that (a) any user can see all the
worksheets in the workbook, and (b) perhaps if I click on the worksheet name,
I can go to that worksheet?