I am an archaeology student and I am trying to make a catalog workbook for
artifacts. We have the artifacts cataloged by bag number and FS#. What I have
done is entered the FS# and bag number as names of the worksheets and then I
total the worksheet on as FS#-T page. However, occasionally we encounter a
new type of artifact and have to add a new row for the artifact. Thus, we
select all the sheets and add a new row to the catalog form. However, this
affects the formula sheet, and the summation formula does not appear in the
new row. Is there a way to make the column that is adding information for the
separate worksheets equal the formula so that when we insert a new row for a
new artifact, we do not have to go back and copy and paste the formula. Right
now, it is not problematic, but in the summer I will be dealing with a large
number of worksheets.

Also, I noticed that the sum function has a limit of 30 numbers. I know that
at some point I may exceed this in my summations, particularly when I create
a page that totals the results from all the FS#'s (we currently have over 500
FS#'s). Do y'all have any suggestions on how to deal with this?