I can get the code for sorting data into order, but what I want to do then is
filter by each different entry and copy the visible rows.

Is there a way of telling it to apply an auto filter and then go through
each name in the list for column B, copying out the results