External referencing using cell values

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