Complete a sports day Google sheets to pull results together

I have created a Google sheets to gather sports day results. The events and information needed are already set up including points awarded for positions. We have 2 school taking part and students are competing for their continent. I need to be able to separate the results into the different schools, continents, years groups, continent by school and for this to be pulled together onto a 'results' tab. It is important that this works in Google sheets. I have attached a copy of the current spreadsheet.