If the workbook you are retrieving values from is always open, you can use
indirect

=Indirect("'[Report " & Text(Date(Year(today()),Month(Today())-1,1),"mmm
yy") & ".xls]Sheet1'!A1")

--
Regards,
Tom Ogilvy

"ronbo" wrote in message
...
I have a workbook that I use month to month named "Report
MTH YY" This month the report is named "Report Jul 04".
Next month the report will be renamed "Report Aug 04",
then "Report Sep 04" etc.

I have formulas that reference last months report. As
simple as " ='[REPORT Jun 04.xls]Sheet 1'!A1". Next
month in "Report Aug 04" I want the formula to reference
the Jul report i.e. ='[REPORT Jul 04.xls]Sheet 1'!A1" .

I am looking for a way to automate the process rather
than manually using "Find & Replace", but I do not know
how to get the month names to change automatically.

Thanks for any help.