I need some help with a formula to calculate the total of monies collected by
Teams for a Relay. I want to make a Summary on one sheet based on data on
another sheet.

Team A has 15 members, Team B has 10. Money totals collected by members are
in Sheet 3 and I want the summary to be on Sheet 1 by Team.

Here is a sample of the data.

Team A, Member 1 collected $10
Team A, Member 2 collected $20
Team B, Member 1 collected $30
Team C, Member 3 collected $5

How do I get the total for each of the teams? Thanks so much.