Summary Sheet for Employee Names wit the Text of Their Location Reported on Summary Sheet

I have 7 sheets with the same employee names for shared employees. Each project manager fills out their sheet with their jobs and what people they want. Next to that employees name they will enter th...