Vlookup.. Or SUMIF's?

[carrieuk]

Hi,

I have a excel spreadsheet that we use for wages, it has a front tab with the names listed in Column A and the sites in Row 1. Not every person works on every site so someone might work on 1 site out of 8.

My question is I am trying to put on the back of these individual sheets but I want it to look up the persons name and list the sites they have worked at - I can then SUMIFS the site names and person to get the values. I've attached a mock up version of what I'm trying to do - it's very basic but I am trying to learn.

I'm not sure what formula to use.

Many thanks

Carrie