Referencing a linked cell in a formula

[Nomic]

Hello All,

I have a workbook that references other workbooks to create a master sheet, not using SQL or query builder, simply "='[workbook.xlsx]Tabname'!A1" etc. Within the workbook i have linked cells that open the work that its referencing when double clicked (standard hyperlink).

Does anyone know if there is a way to link these two things? i.e. have the formula use the hyperlink reference and get the information that way? maybe an indirect?

Any help would be appriciated

Thanks