Arrange data from table

Hi,
I have a list with many details, and I would like to extract the details and sort them by rank.

as you can see in the attached file (this is only an example of the huge table I have), I have list of countries (column B), in each country I have sites (column C) that generates X revenues each (column D).
I already added a rank formula to arrange the order of revenues within the table (column A - I removed the actual formula in the example attached).

now I'm trying to have a list (as can be seen on the right) for each country arranged by rank (1,2,3...) with the name of the site and its revenues.
I struggled with Vlookup , If's , Sumproduct formulas, and others, and I can't find the solution.

your assistance is much appreciated
thanks.