Offset/vlookup in a sumifs function

[kakaman]

I have two sets of ranges in two different tabs.

One has A through D with values going down. The other range has A through D (in different order) with the Country of Origin. I forgot to add, the order of the excel file is incorrect. The Country of Origin column is in B and A through D is in C. I cannot change it as it is locked from another party.

I want to get the sum of the values based on Country of Origin using sumifs. I tried offset and Vlookup, but had no luck.