Index of worksheets

[Guest]

Hi
I have workbooks containing upward of 60 sheets, I use these to record Auto
Accidents under a motor fleet insurance policies, each sheet name tab has a
vehicle ID number and a date on it, the sheets are in the order that they are
produced.

Is there a way of creating another sheet in the workbook to act as an index
of all of the other sheets. I like to type all the sheet names in the index
and have a cell that if click on it takes me to that worksheet.

 

[Ron de Bruin]

Hi mickward

1)
Right click on the Arrows next to the first sheet tab
you get a list with all your sheets

2)
Check out
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Bernie Deitrick]

Mick,

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

HTH,
Bernie
MS Excel MVP