Hi guys,

I have a spreadsheet that needs to get data off another spreadsheet but the problem is a new report comes out daily with the same prefix filename everyday but the only thing that changed in the filename is the date in the end.

ex: SignOn-Agents-UTOPIA - 2012-04-18 - Mercredi1.xlsx

How can I pull up the data depending on the date i put in a specific cell?