How to insert a reference into a HYPERLINK function relative to current cell

[Lukemars]

I'm trying to automatically create a hyperlink to a specific cell using the Hyperlink function.


=HYPERLINK("#'AM 5819 0001'!D10",

IF(D13<>"",CONCATENATE($AA$2,D13),"")

)
​

The first line is the cell reference, the second is just specifying what to display based on whether theres a value in the cell D13.
This formula works, but the cell references the cell D10. I want it to instead link to the D13 cell used in the second part of the equation.

I can use the equation below to call the specific cell i need based on the current cell,
=CELL("address",INDIRECT(ADDRESS(ROW(),COLUMN()-25)))


Is it possible to combine these two? I have tried but it returns an error. Code as below.


=HYPERLINK("#'AM 5819 0001'!CELL("address", INDIRECT(ADDRESS(ROW(),COLUMN()-25)))",

IF(D13<>"",CONCATENATE($AA$2,D13),"")​

)​

Thank you in advance!