I have 2 Excel files. One named "Actual" and one named "Budget". In each
file are tabs for the months of the year, "Jan" "Feb" "Mar" etc. The Budget
file Jan tab cell A1 is referencing the Actual file Jan tab cell A1. The
other months tabs are added as the year goes on, so in February, the Actual
file Jan tab is copied to create a new Feb tab within the Actual file. The
information in the Actual file Feb tab cell A1 is adjusted.

What I would like to do is then to copy the Budget file Jan tab to create a
Feb tab within the Budget file. I would like the Budget file Feb tab cell A1
to automatically adjust it's reference to now reference the Actual file Feb
tab cell A1 (instead of the original reference of Actual file Jan tab cell
A1).

Lotus 123 has this functionality built into it's software. If you have tabs
named "Jan" "Feb" "Mar", it recognizes the sequence and when a "New Sheet" is
added automatically calls it "Apr" and changes any cells referencing "Jan"
"Feb" or "Mar" to "Apr".

Could someone please help me do this in Excel. Thank you in advance.