Create the hyperlinks in A3 and A4 on the original sheet before you copy it 54
times.

InsertHyperlinkPlace in this Document.

Additional stuff...................................

You could whip over to David McRitchie's site to see his creating a TOC pages.

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

Or see Debra Dalgleish's site for similar using a Toolbar.

http://www.contextures.com/xlToolbar01.html


Gord

On Fri, 18 May 2007 22:27:00 -0700, Kent K
wrote:

Also, I'm trying to figure out if I can select the same cell in all sub
worksheets and "mass" hyperlink to the TOC. The first two worksheets are
named State Directory (SD) and Regional Directory (RD) respectively. From
ws3 onward, all page layouts are identical, allowing two cells, (A3 & A4) to
be used for hyperlinking to the two directories. I would like to be able to
type SD into A3, and RD into A4 and apply it to all worksheets as well as
being able to create a hyperlink to the directories intended. Is this
possible? Thanks for the help!!