Complicated task of avg, rank, and sorting

First, thank you for reading and helping on this tough one.

I have a workbook from a sporting contest. Each team is given a total score from judges. I copy and paste the team names and their scores into the workbook under their corresponding site and round. There are a prelims and semifinals events at separate locations. The scores have to be averaged between the prelims and semis. Then the averages have to be ranked to determine the finalist for the event.

Prelims
Site #1 - 61 teams top 32 teams advanced to semis
Site #1 - 61 teams top 32 teams advanced to semis

Semis
Site #1 - 32 teams
Site #2 - 32 teams

Finals is the top 15 average scores of the 64 teams between the two sites.

When I copy the scores in it looks like this in corresponding 3 columns.

1 Lampeter-Strasburg HS ( Lancaster, Pennsylvania) 87.33
2 Hart HS ( Newhall, California) 87.31
3 Dartmouth HS ( Dartmouth, Massachusetts) 86.5
4 Daphne HS ( Daphne, Alabama) 83.94
5 Hickory Ridge HS ( Harrisburg, North Carolina) 80.81
6 Plainfield HS ( Plainfield, Illinois) 80.05
7 Kings HS ( Kings Mills, Ohio) 78.87
8 Colonial Heights HS ( Colonial Heights, Virginia) 78.85
9 Shenendehowa HS - A ( Clifton Park, New York) 78.42
10 West Milford HS ( West Milford Township, New Jersey) 77.01

I have the 2 sites separated in my workbook and I have separated the prelims and semis. But I do no know how to average the teams between between the sites and contest since they will have different rankings from prelims to semis and will not be in adjacent columns. Then I need to sort or rank the average scores to determine the finalist.

I have taken screenshots of my current workbook. If anyone can help that would be greatly appreciated.

https://www.dropbox.com/s/0h0ycduxz5...19.50.png?dl=0

https://www.dropbox.com/s/o3fp5rdo3z...19.58.png?dl=0

https://www.dropbox.com/s/zbu6dl086p...20.04.png?dl=0

Can anyone help?

Does anyone have any thoughts?

I personally would be afraid to go through all of this to get a more complete understanding and try and solve it all for you.
Maybe it would be beneficial for others who are more experienced than myself if you could create a smaller scenario worksheet?
Kinda like

Prelims
Site #1 - 8 teams top 4 teams advanced to semis
Site #1 - 8 teams top 4 teams advanced to semis
Semis
Site #1 - 4 teams
Site #2 - 4 teams
Finals
TOP X average scores of ...
"Finals is the top 15 average scores of the 64 teams between the two sites."
I'm having trouble understanding this.
So what are you averaging. don't you have two sites, each with 32 teams? I guess i'm confused on what exactly is being averaged

Why would you average two separate teams' scores together? Isn't the goal to select the top 15 teams?

Does someone have any thoughts on how to create this function and formula?

Can someone help?

I want to be able to paste the scores in their corresponding site and round. Then have excel average and rank the scores between the prelims and semis for each team.