Sum multiple columns based on header

I have a sheet with information like the following
2013-08-14_12h39_56.png

And wish to create a summary sheet in like so

2013-08-14_12h41_10.png




And I need to write a formula that will lookup values in row 3 on sheet 1 based on the name in column A of sheet 2 and give me a sum of the values beneath it for every occurrence of it. In this example bob appears twice so we need to find the total for both columns.

Sheet1 will be for one month only and a new sheet will be incorporated for any new month.

I have got lost in sumifs and sumif's and now my brain has exploded so any help appreciated.

Thanks for the quick response..

Response to JosephP

This works perfectly for my example given but when transposing it to the real world sheet I have a problem - some of values in the range Sheet1$C$4:$G$100 have descriptive text values in them (such as holiday or bank holiday) which break the sumproduct as they return a #value! as the formula steps through.

other than a reworking of the way we record holidays, any thoughts on a way round this?

Response to MarvinP

Piviot Tables would be lovely. Unfortunately I will not be able to change the practice of how the data is currently captured so unless there is an easy way of converting the format I have into the one needed for a pivot table then I will have to try and figure out using just a formula.

This looks perfect. Now I just need to work out a way of the formula picking up the filename of the sheet it is referencing by a variable set in another cell and im done :D