help with INDIRECT formula

I used the indirect formula in the column TARGET (G5) to have a full path with file name, file extension, work sheet and a specific cell i need the value from, but it doesn't give me any result.

it works in the cell G16 where i have the same formula you can see in F16 which i typed manually.

any idea why is not working ? and how to fix it?

the idea is to have later on the column A as a drop list and use it to index and match with column G so i can have the value in G16 to change accordingly. thank you for your time