Google sheets customization and coding

I have one "almost ready to use" employee timesheet in which employees will keep time, for work performed in multiple locations with their own payrolls, The employee indicates the location on a line by line/ workday by workday basis using a dropdown.
*There are a few issues with the formulas on the timesheet that need to be tested and corrected, , and minor tweeks to the timesheet are needed to ensure a smooth user process. So part of the job is to check and test this sheet to make sure everything is set up correctly.

I then need to separate google sheets, two per location, one for each employee type. So that would be 10 additional sheets that this information would feed into, to separate payroll by location for the two employee types since they are paid by different entities.

Looking at the attached timesheet, I this employee is a DOC (the alternative would be WC), so I need his days as DOC to go into the appropriate Mallard Creek spreadsheet, and the appropriate Riverbend spreadsheet so payroll can be processed for those two locations...and if this were an employee that is a WC and not a doc, I would need the data to show up on spreadsheets for WC's in whichever of the five locations.

These will all be in my google drive, and I will make copies and place them into the appopriate folders for various employees, so employees can access their folder, and keep track of time, and the data will all populate into the appropriate spead-sheet for the bookkeeper to use to process the payroll.

Finally I need a means of clearing all the spreadsheets for the next up coming pay period when the payroll has been processed, which could be a button of some sort that could be created? Guidance and advise on that is welcomed.