I am trying to create a spreadsheet looking like:
date1 date 2
date
name =vlookup(name,file name date1 ,2,false) vlookup(name,file name
date2...)

I need to Vlookup data from different files within same folder, the files
names contain a date within : eg. New format 1.12.2005.xls, next New format
2.12.2005.xls.

The spreadsheet I am trying to create has each column heading with a
different date and based on the date I would like to reference the file whose
name contains the date and return the value from that file. How can I do
this? Can anybody help me?

Thank you!