I need an excel expert

I have an existing excel tracker used for tracking events completed by trainees in Basic Combat Training. There is a tab for each company(A Co - D Co) that needs to be able to fill data for at minimum 265 trainees per company. The main task on these tabs is to make it so that when raw scores are put in for each Army Combat Fitness Test(ACFT) event that it pulls the point score from the event scales. Scores are filtered by gender and age groups. There are 4 additional tabs(Roll-up, BN ACFT 1, BN ACFT 2, BN ACFT 3) which are meant to compile all the different companies data and give total numbers/percentages of certain fields. The attached sheet is a skeleton of what was previously used, the ACFT scores currently reference a different table and not the new one provided. Many of the formulas have been inputted wrong or don't reference the proper material. I would just like someone to clean this up and make it function properly. Hoping this can be accomplished no later than 06 April 2022