here's the problem -

woorkbook with 12 worksheets, that contain 12 columns, and 50 rows of data
each.
there are auto sums running on many of the rows and colums.
there is at least one column where the rows sum across all worksheets from
start to end.

i need to add more rows in the middle of the worksheets but want to
accomplish this without having to correct all of the auto sums and especially
the sums that calculate the worksheets as a group.

currently, when a row is added at 40, the data originally in row 40 moves to
41 but still looks for data in row 40 across all worksheets.

if i have to change each cell manually to account for the addition of the
new rows it could be a couple hours worth of work.

any ticks?!?