List of data based on name

[sinspawn56]

Hello,

I have some raw data that contains a name and a reference number among other things. On another sheet I would like to pull the list of all the reference numbers for a name from the raw data. I tried using an index mach but I cannot figure out how to pull the next consecutive reference number for that name.

I have attached an example.