External Links Causing Issues

Hi, I am facing an issue with external links. Would be great if someone could help me out with this. The detailed issue is explained as below in the best way I can.

I have 2 Files : Master and Current

Master File contains all names of projects handled by multiple people.

Current File contains names of projects that follow different process.

I have created an external link to link cells in current file to Master file.

=[Project Timeline_1H.xlsx]Current!$A$5

now when I delete a row above 5, my formula still refers to A5 cell even though the value has moved up in the process of deletion. I want to retain the link to the value in the cell I initially decide and not to the one that is present in the address of the formula. Can someone help me out. I hope I have explained this fair enough.

use this

=INDIRECT("'[Project Timeline_1H.xlsx]Current!$A$5")

Thank you for your reply.

Your solution is is giving me the #REF! error. Can you help further.

Sorry, I didnt checked before posting,
try this (missed to put ' before the !)
=INDIRECT("'[Project Timeline_1H.xlsx]Current'!$A$5")

I am afraid it is not a syntax error. It's something else. I tried keeping the formula free from syntax errors. but its not helping.