Hyperlink referencing
 

I have used Bastien Mensink's excellent add-in (ASAP Utilities) to create a
Hyperlink index for many sheets in a workbook (currently 64). A master
worksheet has been copied and of course the result has names 'Master',
'Master(1)', Master(2),...etc.
I wish to retain the sheet names as created - each sheet has a client name
in Cell C2. The generated Index Sheet has in Col A, the names of the sheets
and I need to produce in column B the name appearing in Cell C2 according to
the link in Index Sheet Col A.
What is the method ?. I have tried manually (using =<select C2 on required
sheet)
and it works perfectly. But I cannot find the function or syntax to get a
copyable formula to work.
Thanks in advance
--
Don C