Hyperlink to Cell in Another Sheet, Sheet name autofill

[baxterm]

Hi,

Apologies if this has been addressed somewhere else but after much search I've been unable to find it.

I have a workbook with a bunch of sheets which are named simply as a number (starting at 1 and continuing).

I have a contents sheet, a few other sheets and then the numbered sheets being.

I wish to hyperlink a cell in the contents sheet to Cell A37 in sheet '1' and then hyperlink the below cell to Cell A37 in sheet '2' etc etc so the cell referenced stays the same but the sheet number goes up each time.

I've tried using a combination of ROW and INDIRECT among other things but I can't get it right. I don't mind if the friendly text for the hyperlink remains consistent with a simple "go to" or something like that.

Thanks in advance for any help, I'm hoping I'm just missing something simple.

 

[Yongle]

Welcome to MrExcel

formula in first cell and drag down (or copy down)

=HYPERLINK("#"&ROW(A1)& "!A37",ROW(A1))

 

[baxterm]

Welcome to MrExcel

formula in first cell and drag down (or copy down)

=HYPERLINK("#"&ROW(A1)& "!A37",ROW(A1))

Thank you! This was perfect.