yodacaia

You can use the indirect function to do this, take a look at the formula below

=INDIRECT("'"&"C:\Windows\Program\["&a1&".xlsx]Sheet1'!$G$8")