Here is my vlookup formula:

=VLOOKUP($A6,'[Feb 09 $7 Report.xls]By_Rep_by_Filter'!$F$1:$P$5000,8,FALSE)

Which works. However, the spreadsheet "Feb 09 $7 Report" changes every
month. So next month it will be "Mar 09 $7 Report". I want to use a wild
card in the table_array so that no matter which months report I have open it
will know to look at the $7 Report. I tried this:

=VLOOKUP($A6,'[????? $7 Report.xls]By_Rep_by_Filter'!$F$1:$P$5000,8,FALSE)

and this:

=VLOOKUP($A6,'[* $7 Report.xls]By_Rep_by_Filter'!$F$1:$P$5000,8,FALSE)

but neither of those works. How do I accomplish this?