VBA Expert needed / Dont say crazy price please -- 2

Job ID: 38050429

Budget: $50 – $60 USD

Anyone knows how to do VBA really well? beginners are plus point and if cost is affordable, experience is also plus point. I have attached our excel file and what is the process of doing the work. The work is self explanatory. I need you to bid on this project after checking if you can do it or not. Dont bid generic bid. It wont be accepted.

Questions
1) Which part of this can be automated accurately?
2) Which part should be done manually but is easy to do so in excel?

https://drive.google.com/drive/folders/197CtL9gwXuLApgCp9hdNrbUnXEEjd2vr?usp=drive_link