Copy grouping from 1 spreadsheet to another

Each week I am given a spreadsheet that contains names in left column and all their competences across the row at the top. My supervisor then wants me to group the names into department groups. I do this manually for 140 employees. Is there a way to make a template that the original spreadsheet can be dropped into. I can not change the original spreadsheet, only my copy.

if you have a list of the 140 employees and their respective departments you can lookup this table in the sheet with competencies. I attach an example -

Dave H

Thanks, That seems to be what I want... Cheers