Thank you. A lot of stuff to go through but the answer is within.
--
Thank You!


"JE McGimpsey" wrote:

Take a look he

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

In article ,
maijiuli wrote:

Hello,

I have a workbook with 120 worksheets. I created an Index worksheet with
all of the names of each worksheet (A2-A121). Now I wish to somehow easily
hyperlink the index names to the worksheets. The worksheets and the index
are named exactly the same. Thanks for looking,

Mj