Hyperlink query
 

Hi

I have got a spreadsheet with around 50 worksheets. Each worksheet is
related to a person, and there is a summary table with all of the people
listed, This is called "Totals Page". The peoples names are listed from cells
C9:C59.

Each persons worksheet has got their name in cell B2.

I would like to create a Hyperlink so that when I click on the persons name
in their own worksheet it takes me to their name on the Totals Page.

Is this possible?

I have created a Hyperlink to take me to the Totals Page, but I have to put
a cell reference in there, meaning that when I click on the Hyperlink it
takes me to the same cell everytime and not to the persons name.

I have tried to use lookup functios as part of the formula but they didn't
work.

Thanks

Mark