loops

I have an excel export that uses specific fields from a file. I would like to sort and only show certain data from the file in the export and agian in another export with different information. For example:

Name

Bob

Bob

Susan

Susan

I want to have all Bob's information on the excel spreadsheet only and then have another spreadsheet with only Susan's information. Than I want to e-mail to the appropriate person with only their information. How do I accomplish this?

Thanks,

Shari