So for example i have an excel file called XYZ.xlsx ; in the H column i want to have '[XYZ.xlsx]tab1'!J3 but this is the code for manually referencing ; what i want is that the value of cells in the G column are used for referencing
so the code in H column would be something like ='[G5]tab1'!J3
the G column has the hyperlink to the wanted excel file

hope this makes it clearer :p