Is it possible to sort of make a mail merge within excel?

Say I have 5 sales people who sold 100 different items.
In fact, I will have a 2-column, 100-row table (well, 101
if we include the header).

I'd want to be able to create 5 additional and new
spreadsheets each listing just the items that each person
has sold.

Currently, I just make a pivot table, create additional
sheets and do a cut and paste. But I'm hoping someone can
come up with a more simple and elegant way to do this ;)

Kind regards,

DSK