Question about merging, coding and the like

Good Morning,

I'm an Excel 2007 newbie

I have a list of donors 98,000 names, addresses, e-mail addresses on 7 spreadsheets and I want to put them all into one can I merge them? Secondly, I would like to be able to retrieve the specialized lists such as seasoned donors, gift of one time donors, etc can I give each name a code in a column and then set an array to pull up those donors? Eventually I would like to utilized the specialized lists for either a mailing or an e-mailing of a newsletter or both.

Any assistance would be great appreciated.

Thanking you in advance.

Sincerely yours,
Michelle

Make sure the columns are exactly consistent across the different sheets, including one or more columns that characterize each donor. Then just copy all the data to one sheet, and sort by the appropriate fields.

Just to slightly clarify SHG's suggestion, you can sort and filter to achieve your objective or even use a pivot table after establishing the coding mechanism you want to use. That should do it.