How to auto copy/pull information from a master tab to several work sheets

I am creating a spreadsheet that has a master tab of information and will contain information such as name, address, status, paid status, method, etc. then I want to have seperate tabs that have all the people who paid in 2008 another for 2009 one that shows all active members and another that shows alumni. Does anyone know how to do this? Please help. I need very specific step by step (easy - 5th grade language) instructions.



Example of Master Tab

Last First Status Address City State Zip Telephone Email 2008 Date Method 2009 Date Method

Smith Joe Active 4587 McKinney Dallas TX 75219 214-870-9254 [email protected] $ 300.00 1/17/2008 Paypal
Martin Mike Alumni 1200 Central Dallas TX 75205 214-874-1268 [email protected] $ 150.00 2/7/2008 Check $150.00 12/19/2008 Paypal
Sanchez Carlos Active 4185 Cooper Highland Park TX 74856 214-875-1146 [email protected] $ 300.00 1/7/2008 Paypal $300.00 12/17/2008 Paypal


Thanks



Sara

Thanks for trying...I don't want to copy and past and filter data every time there is a change. This is a spreadsheet that will change and I want it to auto update and fill in the "child" tabs. There are formulas that you can use that will allow you to have a master tab and then if a certain cell says "a" it will copy it (automatically) to the tab labeled "a" and so on and so fourth.

Thanks for trying though!

But, shouldn't there be an easier way. I found a post where there was formulas that would allow you to create a master tab. And, once that was done you entered in a formula. ex. if there was information in the 2009 column it would automatically copy and paste that to the tab that was labeled 2009.

I am looking for formulas to automatically do this. like if I have a certain value in a cell it picks up on that and puts it where it needs to be.