Try Sumproduct()

e.g.

=Sumproduct((Sheet1!$A$2:$A$100=A2)*(Sheet1!$B$2:$G$100))

adjust sheetname and ranges to suit.

P.s. Please don't use words like Urgent in your titles... we answer questions as we see them and are able to answer them.. not based on urgency