Hyperlink loses link if cell moves

[Corleone]

Is there a way of retaining link to a new cell address in a Hyperlink if a row or column is inserted

for example i have a link to cell aa5 if the user inserts a column the hyperlink just links to the now aa5 empty cell and not to ab5 the new location of the data

thanks

 

[Corleone]

ive found a part solution to this where i can use the following formula
=HYPERLINK("#"&CELL("address",BD5),BD5

this replaces the previous for,ula =bd5 but also serves as a hyperlink



however, i need to do the same where i can put a hyperlink on a cell which has a vlookup formula on it e.g.

=IF(ISERROR(VLOOKUP(AA8,'E&P Data'!$A$2:$F$5000,3,0)),"",VLOOKUP(AA8,'E&P Data'!$A$2:$F$5000,3,0))