Need to Create Foreman Time Sheets based on Who Employee is assigned to

We have an unusual situation in which we move manpower around daily which creates alot of work to create Daily Time sheets and sign in sheets based on the foreman they have been assigned to. I need to be able to go through a master sheet and assign each employee to a foreman then have the Foreman Daily Time sheet Forms automatically Populate. I also will need to do that with a sign In Sheet. I'm thinking that each foreman will have a their own worksheet inside of a workbook, but I'm not sure this is the best solution. Ive spent the last couple days working on it but haven't been able to make it work. I've attached a file with a data set and what I Need the form to look like on the right

YESSSS!!! Thank You very much!!!!!!!

You saved me many more Hours.