I believe you can use the INDIRECT function to piece together the text
for the reference. I haven't done it recently so don't recall the
exact usage but it might be something like:

=VLOOKUP(C3,INDIRECT"["&TEXT(TODAY(),"yymmdd")&"Cost Centre
1.xls]Sheet1!$D:$F),3,FALSE)

- John