Try SUMIF
Assume your source data in Sheet1, IDs in col A, values in col B
In the other tab, you have IDs running in A2 down
Put in B2: =SUMIF(Sheet1!A:A,A2,Sheet1!B:B)
Copy down
--------
Success? Wave it, hit the little star at the bottom left of my response