I create a monthly profit&loss file that after each month, I do a file SAVE
AS to create next months file copy, etc.
In the file, a Profit & loss sheet refers back to the same month of last
year. How do I create a reference so the when I create the SAVE AS file, it
looks back at the same month.
Right now, i have to go into each cell and change the file look back name...

i.e.='\\easfs\MonthendCorp\2005\[043005.xls]ConsYTD'!$B$6

How do I have the [043005.xls] change to [053105.xls] when I create the new
file?