Generate List based on specific Variables being Met

I have quite a crazy task that has been driving me nuts and nobody at my work knows how to help. I turn to your advice on how to proceede.

Here is what I need to do. A report is generated from a web application that details exams that are missing as well as other data. I specifically at this time need to have a list generated for the missing exams. The list that is generated will need to appear in a seperate country based tab on the same work book. The process must be dynamic for the data changes each time the report is downloaded though the format of the report stays the same.
What I need is a check to see that the following is true for example:
Country is=Brazil
Status=Unresolved
Type=Required Scan Missing
Site=0010
If these are all true then on the next tab I need the following displayed on the brazil tab in the appropriate locaiton with the data that is in the headings such as Exam, Site, Subject, and Query ID.
Seperation of the baseline and Evaluation exams would need to be seperate for each site.
Once I know how to do this i just need to repeat the process for about 123 sites. So if you can help me just get this far Im pretty sure I can get the rest of them.

The attached xls hopefully clears things a bit better.

Thank you so very much in advance for all your help.

That is closer though I already have created each countries tab. I need it to break it down further and create a list based off the example criteria.