I am working on a registration form for a meeting.  I currently have a sheet
set up as a registration form with cells for various fees to be paid by the
registrant.  My current plan is to use a seperate sheet for each registrant
(approx 100 - 150) all within the same workbook.

The question is:  What would be the best way to summarize the various
amounts paid and the numbers of people registered for each event all onto
one sheet?  I looked at using a Pivot Table, but apparently my data on the
registration form is not arranged correctly.  I have been looking at using a
summary sheet within the same workbook, but have not been able to come up
with a formula that will add up the numbers from all of the sheets.

Thanks for any help.

Charlie