Macro to extract conditional, multi-line data

[Magriza]

Hello All,

I'm sure this has been answered before but I can't seem to find it (must be using the wrong search string).

I'm trying to find out how I can extract data on one sheet and display it on another based on the contents of a cell. A little like a vlookup and a pivot table merged.

So it would display all matching rows (like a pivot table), but not all the columns of that row (so like a vlookup I could specify the column number).

Any help appreciated.