Dynamic Hyperlink within workbook

[rachelih]

I have a worksheet with a list of the names of the tabs in the workbook and would like to add a column next to it that adds the hyperlink to the tab. For example:

I can't figure out how to set up the HYPERLINK() formula in excel to do this. I would like, for example, for ABC to go to cell A1 on the ABC tab after clicking the hyperlink.

Thanks in advance for your help!

 

[rachelih]

This actually worked for me:

=HYPERLINK("#"&"'" & A2 & "'!" & "$A$1","Go to tab")