Hyperlink Formula Cell reference change Automatically

Hey Thanks a lot BSB.

I almost bout got it I think.

so I have the below formula now

=IF(I13>0,HYPERLINK("#'"&A13&"'!E"&ROW(E1)+12,$G$11),"")

I have this typed into the example tab, but when I paste it into the sheet tab it replaces the ROW(E1) with ROW(#REF!) and doesnt work, I have to manually type in E1 on the sheet tab for the hyper link formula to work.

see below my file