I want to populate a seperate spreadsheet for each sales person, listing
their sales only, from a master list.

I have been cutting and pasting. I am looking for a way to have the
seperate sheets filled by using a function to select each sales person and
post to their sheet.

I am unable to use the lookup functions because they only select the first
match. I have numerous rows for each person. Their is no other consistant
unique data to search from. My header consist of Sales Person, Date,
Customer, Invoice Number, Cases, Amount Earned.

The sales reports must list each invoice and be seperate for each person.