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.

In O2: =COUNTIF(J$2:J2,$B$2) copied down

In P2: =MAX(O:O)

in D2: =IF(ROWS($A$1:$A1)>$P$2,"",INDEX(J$2:J$27,MATCH(ROWS($A$1:$A1),$O$2:$O$27,0)))

copied across the matrix and down further to ensure all data matching is returned.