Hi Livin,

Visit David McRitchie's site and see his Table of Contents page at:

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


---
Regards,
Norman



"livin" wrote in message
news:wrlWe.97115$Ji4.15580@fed1read03...
I have a workbook with 250 sheets... named like so Sheet01...Sheet250

I want a cell to contain the number value of each sheet (01, 02, etc)
while also being a hyperlink so when the cell is clicked the workbook
automatically displays that sheet.

Any ideas?