Find match from 2 columns in 2 sheets and display result in the second sheet

[abjac]

Hi Have this project i am working on. I need to have a macro which can find the match Between Sheet Middle result column B and Sheet Middle Result1 Column A. And then Put the matching numbers from Sheet Middle Result column D into column B sheet Middle Result1.
I guess its a kind of Vlookup. But the very special is that it have to be country seperated.
The result i have in Sheet Middle Result, is a macro which Jindon so fantastic made. Where he sorted these date, from another master sheet, with allot of data.

Please have a look at the attached sheet. I am sure its more easy to see what i mean there.

Hope some can help with this.

Sincerely
Abjac