What you're describing is the kind of thing one might use a Word mailmerge for; in particular, a directory merge with grouping. To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. Mailmerges allow you to filter by all the names of interest
An alternative is to copy, then sort the data in Excel, then delete the unwanted rows.