How to connect different criteria among 3 sheets?

I added same mock-up data to make it clearer.
I expect to see relevant sum from sheet 'compensation' in sheet 'summary' D:D.
as you can see, each item has a unique id which is used by manufacturer as indicator for compensation amounts issued.
I cannot add any data into sheet 'summary'. That would be easy but that is the thing that I'm not allowed to do. So I'm trying to find a way a

Here's a link to the file:
https://www.dropbox.com/s/2mwmqz07qs...ook1.xlsx?dl=0