Using a parameter in a path to another file

I have the following formula referring to the file [MARKING 116E.xlsm]:

=VLOOKUP($C3;'[MARKING 116E.xlsm]YIELD'!$C$3:$I$4000;3)

I would like that '116E' will not be a fixed value, but will be taken from the cell A1.

Thanks