I am generating a time card management workflow for managing a small crew of employees.

I have a core set of employees, but on any given day I might have an additional number of day-playing employees.

I have a sheet detailing the Daily Time Card of every employee over the course of a week. I would love to have an automated function where a time card template that I have created is automatically generated as a new sheet for every individual whose name appears as having worked for that week (and for that new sheet to auto-fill with the hours worked) based on information present in the Daily Time Card sheet.

Any information would be greatly appreciated!

Thank you.