Data extracting...Not counting.

Hello all.

I wish to perform the following...

In one cell i have a dropdown. Depending on what is in that dropdown, i want a table of data to be written. I'm not too hot with pivot tables but my understanding is that is predominantly to do with counts. This is more of a multiple vlookup i guess. I want to pull from a list of data (3), all the cases matching the dropdown (1) and deposit into a list (2).

What is the best way of doing this?
I don't want to use filters.

Please see attached.