Hi Daniell,

You are in luck!
You can use one of several Excel features to sumarize your data in your
first sheet.
You could use 'Sumproduct' formula, or Data Consolidation (goto 'Data' and
select 'Consolidate', or just use a sum formula in the formula bar (formula
referencing the cells on the different sheets).

It's a little hard to tell you exactly what method to use without seeing
your spreadsheet but believe me it's possible!!! :)
Send me an email with a sample of your data if you like.
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com