Why not put your cumulative total2date at the top of your sheets 2-6
in row 1 (insert a blank row here to move the other rows down) and make
your sum range fixed as A3:A53 to automatically cover the 50 rows in
sheet 1 you will need. This way you won't have to make any adjustments.

Pete