I am using a workbook to manage a database. The last page of the workbook
summarizes the data base by adding the same cell of each worksheet.

When I move any of the sheets in the workbook it appears to no longer
summarize the data correctly on my last summary sheet. I have to go to my
formulas, and copy and paste them.

Although I am not changing the content of any of the formulas in order for
it to properly calculate any new data inputted to the balance of any of the
worksheets will not be incorporated into the calculations.

Is there a solution other than to re-paste all the formulas on my summary
sheet?