Pulling various data that matches specific criteria to paste elsewhere. How??!!!

feel I am just a baby beginner in excel and I'm struggling to even describe what I know I want it to do!

I have -
col A with unique names
Col B with a Month

I need to find the Month and then find all the names associated with that month to paste into another sheet that corresponds with the month.

....... Col A......Col B
row1 Mary January
row2 Mungo February
row3 Midge January
row4 Adam March
row 5 Scott February

so I want to find all the names associate with January and paste them into a specific cells on a sheet for January
and so on.

I want it so that the user completes their list of staff names, and assigns them a month, and it pre-poulates a different sheet for that month.

Does this make any sense.

It was suggested I should be using the Vlookup, but I can't seem to get it to apply to what i want it to do!

Any help would be gratefully accepted to point me in the right direction!

Thanks
Michelle

[QUOTE=Chelle 67;2427265]feel I am just a baby beginner in excel and I'm struggling to even describe what I know I want it to do!

I have -
col A with unique names
Col B with a Month

I need to find the Month and then find all the names associated with that month to paste into another sheet that corresponds with the month.

....... Col A......Col B
row1 Mary January
row2 Mungo February
row3 Midge January
row4 Adam March
row 5 Scott February

so I want to find all the names associate with January and paste them into a specific cells on a sheet for January
and so on.

I want it so that the user completes their list of staff names, and assigns them a month, and it pre-poulates a different sheet for that month.

Hi,

Please find attached a pivot table that might be useful to what you were tyring to do... If you attach a file as to what exactly you were tyring to do would help better than just explpaining it.. Hope this helps...

Also,

What you need is 12 seperate pivot table pulling data from the same source and all you have to do is to refresh button to populate the corresponding names for each months..

Does that make any sense?