Sorting data

I have been given the task of recording all the promotional offers made my each employee in my company each week. I download the spreadsheet from the company database and it looks like this (see attached). I have been requested to sort the employees into their teams (assume team 1 has employee: a,b,c and d, and team 2 has employee: e,f,g and h) which also shows the figures for each promotion per employee. I thought of using a pivot table for this (although I don't know how I would sort it into teams), but he thought of manually formatting the spreadsheet for 100+ employees so that a pivot table can be used is daunting.

Is there a quicker way?

Cheers

Update: Just talked to IT, they may be able to get the names running down the side for each promotion code which means this is no longer relevant.

Could someone please tell me the best way to sort the information on the left into the table on the right.

Cheers

Update: Never mind figured it out.

=SUMIFS($C$4:$C$32,$A$4:$A$32,$G4,$B$4:$B$32,H$3)