I reference a report which is run every week to make a separate report that uses lots of different formulas and updates automatically. The name of the report that I pull from is constant, but the week's date is different every week. Can I ignore the date only so I can reference this weekly report without changing the name or my references?

For example:

A report is run this week called: Dave's Report 111607.xls
Next wee the report will be called: Dave's Report 112307.xls
And so on...

What I currently do is re-save this report as just Dave's Report.xls in another folder and all my formulas reference Dave's Report.xls.

Can I manipulate each of my formulas to only see the first portion of the file name, so I don't have to re-save the report, I can just open the dated report and let all of my references update?