I'd like to set up a formula that references a filename that is contained
within a cell.

my formula currently is:

=VLOOKUP($B3,[02.10.06.XLS]Summary'!$M$6:$T$27,5,FALSE)))

I would like the filename to read from cell C2, which contains '03.10.06' so
it would read:

=(VLOOKUP($B3,[(contentof c2).XLS]Summary'!$M$6:$T$27,5,FALSE)))

This would just save me so much time finding and replacing dates in the
formula, which I am doing at the moment.

Any ideas?