sum data from a DB using another DB with partial information

Dear all,

I don't know if it's possible, but I would like to use a macro to do the following.

I am handling a HR database as the one you see in the sheet "DB":
- each row is a separate ID
- columns B,C,D,E identify the person within the organization (don't worry if some locations don't make sense, they're made up)
- column "Cost" indicates the cost for that person

In the other worksheet "aggregation":
- in column "nr of cases" you have the nr. of cases that satisfy the identification you see in columns B,C,D,E
- I know it is somehow problematic, because not all the cells are filled in
- At the same time, if we consider all the information, all the rows are mutually exclusive and therefore it should be possible to automate the process I describe in my question below.


MY QUESTION:
- in worksheet "aggregation", column "Total cost", I would like to put the total cost for the IDs in worksheet "DB" that satisfy the conditions in columns B,C,D,E in worksheet "aggregation". Is it possible to write a macro that does just that? (it's a 8000 rows DB!)
Many thanks for your help in advance.

f.alf