Automatically checkling ranges and selecting contents based on a value

hi all, can anyone help please?
i attach a zipped excel file which contains the following sheets:

parameters - allows the user to select a given "area" to report on
report - this is where the output would be presented
area a to area d - sheets containing the invidual data collected by each area.

what i am looking for, if possible, is a way, via vba code, to look at the data in the 4 area sheets and, when the Reviewer has been selected in the drop down on the "parameters" sheet cell D3. copy the relevant data to the report sheet.
In my example, you can see that it has returned 6 rows from area A and 1 row from area C.

Any help, gratefully received.
Thanks