Hello,

I have a workbook that tracks production data for an entire month. In
addition to charts and tables, it has 62 nearly identical worksheets that
serve as forms for the user to enter data for each shift (2 shifts per 31
days).

I am frequently updating the design of these forms, adding new tracking
categories and fields. Every month I send the updated blank workbook to the
user.

Currently every time I change anything on the form, I must go through all 62
sheets to update them. I would like to automate this by having a 'template'
sheet that I cna make changes to, then automatically redesign the 62 sheets
to that format. The catch is the sheets do have a date/shift field that is
different so I can't just copy the sheet as is.
Also, I have a summary sheet that is identical in format but sums the data
for each field from all shifts.

how would I go about doing this?