I have used excel to create a workbook where the topsheet is named total and
the sheets below are presently named Property 1, Property 2, Property 3,
Property 4. Each sheet looks exactly like the others. For example cell C1
of each sheet is equal to the property value. I would like to have Excel
sum up all the property values in C1 of all sheets and display it in the
"Total" sheet's C1 cell. I would also like to be able to add new sheets
below the top sheet as I buy more properties, without changing any of the
formulas in the top sheet. Can anyone help me with this. I certainly would
appreciate it.