Automatic update of worksheet name in formula

Amy,

I just ran across your post, and it sounds like we are doing similar things.

I have two workbooks: Budget 2017 and Budget 2018. Actually I have budgets back for several years. Each has 12 worksheets, layed out as a month in each worksheet with the number of lines corresponding to dates of the month. Formulas auto-update budget values for each day and for the month. The end value of each month auto-updates as the beginning value of the succeeding month (i.e., the last entry in March auto-updates to the beginning value of April, and so on).

To create subsequent year budgets, I created a blank budget template. It's blank in that it has no data for expenditure descriptions or associated amounts, but does have all the formatting info, including formulas. I just do a "save as" and rename the saved workbook as the appropriate year budget (e.g., Budget 2019). Then I can fill all the new income and expenditure data and get auto-updated daily and monthly totals.

My problem is getting the ending value of December 2017 (in the Budget 2017 Workbook, for example) to auto-update to the beginning value of January 2018 (in the Budget 2018 Workbook, for example). All I have been able to do so far is "link" the associated cells, and then I can change the value. Any ideas on setting up the auto-update?