Spreadsheet structure: Volleyball tryouts

Hello. I've been working with a spreadsheet to assist with the tryouts for a local JO volleyball club. It sort of works but has some bugs that have bit me in the A$$ multiple times. I was hoping to outline what the spreadsheet needs to do, how I've structured it, and some of the obvious shortcomings I've come across. Maybe you can provide some insights to improve what I've put together so far.

The tryout process: Kids register online prior to tryouts. The kids are assigned to a Group# for graded skills evaluations (Example: 10 Groups/Skills- setting, passing, serving, attacking, blocking, height, vert jump, speed,....). Coaches fill out grades for each skill on small scoresheets. After the skill evaluation period, the kids are assigned to play courts based on their contract status and their cumulative scores during the evaluation period.

My spreadsheet: I get a spreadsheet of the entries the day before. I cut & paste certain columns (ID, name, school, position, contract status, Group#) of info into the Summary table on Sheet 1. I manually insert info for any walk-ups the day of the tryouts. I use an INDEX function to write kids' info to specific Group# worksheets for data entry of the evaluation scores. I use a VLOOKUP & INDIRECT to copy the score data back to the Summary table. I want to sort the entries in the Summary table by Contract & Total Score, but that doesn't work correctly in the table. So I end up copying/pasting as value the Summary table to another worksheet. I make that a table and then sort as desired. We then manually assign/enter Playing Court# based on their rankings (Example: top 8 kids to Court 1A, next 8 kids to Court 1B, next 8 kids to Court 2A,...). I make sure that table is then sorted the same way that the original Summary table was, then copy/paste the Court# values back into the Summary table. I again use an INDEX function to write the kids' info to specific Court# worksheets that have a coaching evaluation sheet format that we quickly print out & hand off to the coaches.

The goal is to minimize the time between the conclusion of the skills evaluations and when the coaches have the Court# evaluation sheets printed out. The additional steps required to get things sorted correctly since it doesn't function in the Summary table is the biggest time lag currently. Any ideas to structure this in a better way?