David McRitchie has some code that creates a table of contents (using
hyperlinks):
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site.

franklin85 wrote:

Hello people,

I have a query regarding hyperlinks. I have a summary page of around 90
organisations, each of which has its own tab within the work book.

I was wondering if there was a macro or something which would save me having
to go through the list of organisations one by one and creating a hyperlink
individually to its related sheet. The organisation names all are the same
as thier related tab name within the work book.

Many thanks for your help

Franklin85

--

Dave Peterson