Pay Bonus Calculator Formulas

Good Morning Everyone!

I am trying to build a new excel spreadsheet that will allow me to calculate all the bonuses of my employees based on their performances for easy help when it comes to payroll time.

To do this I need a lot of help with formulas!! I have attached my spreadsheet for reference.

Basically, each employee, listed on the tabs on the bottom of the spreadsheet, will be given a daily score which is recorded under the appropriate date on the calendar for that person. Then, I want the excel file to calculate their monthly average from the scores produced and relay this to a month review sheet.
In the month review sheet, I would like to have it so I can enter the monthly sales of our company and have the sheet calculate how much money is available for bonuses based on the overall team percentage. For example, if the overall team score was 80%, then 2% of the monthly sales would be allotted to a bonus pool. If the overall team score was 90%, then 3% of monthly sales would be allotted to a bonus pool, etc...Then, from this monthly pool, I want the funds to be split amongst the six employees based on their performance. For example, if they get a 90% monthly average they would get a bigger portion of the bonus pool than a colleague who only scored a 70%. I need some ideas and suggestions for how I can use formulas for this, so that the operator of the spreadsheet only has to input the monthly sales amounts, and the daily scores of the employees.

I would be very appreciative of any help I could get!!

Thanks a lot,
Yorke

Thanks Siva and Glenn,

I have looked into it a bit more, and it would be more fool-proof for the operator if they were prompted with a user form when they first open the spreadsheet prompting them to enter the monthly sales right away. It would also be nice if they could choose the current month from a drop-down list at this point too.
I have started the user form in VBA (see attachment), but I don't know how to program it or insert a drop-down menu - maybe someone could help??

Thanks,
Yorke

Not really, but I would like to add this to the User Form as seen in VBA, and then this would update E1 accordingly.