External referencing using cell values

[Mark_H1090]

Hi

I need to reference an external file for cell values within a worksheet which is straight forward, however, I need to substitute the file name the link is referencing with the text of a cell value as below (essentially C6.xlsx below) as the sheet is generic and is replicated with different file names for every project and I don't want to have to create the new links for every sheet. Is this possible? This would enable me to reference the correct sheet every time I create a new sheet

Thanks

[#2]

@Mark_H1090 

Afraid not. INDIRECT() could work, but only if other file is opened.

[#3]

Thanks Sergei. I think I will automate it with a data link to the file and fixed cell destinations. Not as smooth as I would like but it works.
Appreciate the response.