Update Tab References when Dragging Formulas to Adjacent Cells

PdM_Rob 

Rob, in addition,

If your months sheets have exactly the same structure and the same as for template, you may name your resulting cells as

In Name Manager it looks like

In general you could name them in any one month sheet, not necessary in Template.

In Data Summary sheet in title for months better to use any date within the month, drag to the right with Fill Months and format as "mmm".

Next, in summary row for Parts Records

use formula

=INDIRECT(ADDRESS(ROW(PartsRecords),COLUMN(PartsRecords),1,1,TEXT(D$1,"mmm yyyy")))

and drag it to the right expanding on all months.

Similar for other records, I guess it will be about ten records.

With that, changing months layout, you need only adjust references for named values. Or do nothing if you change layout by adding/removing rows or columns, if so referenced shall be adjusted automatically. The only point is to have the same layout for all months.