Will it be possible to add a variable as a parameter for the link? as shown
below format, therefore, I can change its parameter based on certain cell
value to link different spreadsheets? for example

Original
'[filename.xls]6220.HK'!$E$2

Modified approach
'[filename.xls]C2.HK'!$E$2 , where C2 = 6220, which equals to linking
'[filename.xls]6220.HK'!$E$2

Thank for any suggestion
Eric