I have multiple pages, each reprresenting a single property that I own. The
topmost page is named "Total" and the final page is named "99". Each
property is named differently, depending on the property number that I have
given it. Each page is exactly the same. On each page is a cell, (C3),
that is the "total cost." I would like to have the top sheet, named "Total"
automatically add all of the C3's on every page and show the total. I would
also like to be able to add blank pages before page "99" and have all the
formulas work without doing any changes. How do I do this?