I need to calculate the year-to-date actual in a financial sheet.
Last months data is accessed by the reference shown below.
Defined Name Paste List:
My_ytd_act='D:\DATA\zzz_inc\[rev0105.xls]Indperf'!$H$9

This works OK, but each month the workbook name, rev0105,
has to be changed to reflect the previous month’s sheet.
Is there a way that this reference can be built or generated from information supplied within the sheet itself?
Thanks,
jfw