Totalling Separate Worksheets

[Guest]

I am the Financial Secretary at my church. I have a worksheet set up for the
weekly deposits. I then have 20+ worksheets for individual member
contributions that they need each year for tax purposes. How can I total
those 20+ pages and see if that total matches the total contribution
worksheet?

Thanks for your help.

 

[JulieD]

Hi

is there a cell on each of the 20+ sheets that contains the total (ie in
cell D27 of every sheet i'll find the total contributions for the person),
if so, then summarising them can by done by the use of a formula like
=SUM(firstsheetname:lastsheetname!D27)
this will sum everything in cell D27 between the first sheet on the left and
the last sheet on the right.

If however, they're not set up like this, maybe if you could reply with a
description of how they are set up we might be able to come up with a
workable solution. (please just type out your description, don't attach a
workbook).

Regards
JulieD