Automating monthly project allocation sheet

I want someone to automate my monthly project allocation sheet. This project allocation sheet is used on a monthly basis to allocate projects to different team members, based on a number of criterias. This particular project requires extensive coding and data science skills, and the ability to thrive in ambiguity.