Greetings all!

My name is Audra and I'm an executive assistant for a dance company and I
have a query.

I'll just jump right in.

We want to create Sheet 1 as an itemized sheet, something as simple as
listing 10 students' names, how much they paid for their one Salsa class and
the sum followed by a second list of 10 students' names, how much they paid
for their Tango series class followed by its sum.

Sheet 2 needs to be just the sum of the Salsa class and the sum of the Tango
classes.

Is there a way this can be done automatically, transferring sheet 1 to sheet
2?

Any help would be greatly appreciated ASAP.

Many thanks.