Excel lookup formula

I need a formula to do the following

look up a name in column A1 on sheet1

then look up that name on sheet2 in column A1:A6

when it finds that name it need to look in column B to find a date, if that date matches January 2014 it has to look up the value in column c and add all the values it finds for that person in January 2014