Copying donations to program designation sheet.

Hello,

I am trying to make an excel woorkbook for our nonprofit organization - Restavec Freedom Alliance. At this point I have one sheet that includes all donation data- sort of like the master list. All the donations have program designations, for example: building fund, school, et cetera. I would like all entries to be sent to the according sheet based on that program designation.

I know I can use the sort & filter feature but I would like to have them on different worksheets. Is this possible?

There are also some other things I would like to do, for example - report how much each person has donated throughout the year , quarter, and so forth.

This seems like an amazing forum and I look forward to working on this, thanks!