ok, I have multiple names I need to extract along with all the data on the
same row to another sheet. These names will appear multiple times.

There's about 2 hundred of these I do daily. Again I need to focus only on
the names which one person's name could apear 10-20 times in any order and I
need all the data associated with in the row to move to another sheet.


ex:
djones red bike
marce green shoes
phaul red gloves
marce blue hat
phaul green bike
djones blue ball

hope i was clear on this
tia
Don