How do I pull data from multi sheets into one?

[Jami]

I am putting together a spreadsheet of donors. Using a new sheet for each
week. How can I pull their information together for a year end letter?

Thank you

 

[Megan]

I would set up each spreadsheet the same. So the totals are in the same cell
on each page. Insert a tab calling it First before your first spreadsheet
and add another spreadsheet after the last of your spreadsheets calling it
Last. You can hide these after you are done..but do not enter spreadsheets
in between these two tabs unless you want them to also be in your totals.

Create a summary tab and in the same cell enter "=SUM(First:Last!I27)" This
will total everything into the summary page.

 

[Bob I]

Use a database instead and have a field for the week in question or do
the same thing on a Single sheet.