Sort cells to other worksheet?

[Excelforum*ser_mH7]

I've got a list to activities to do and a colomn telling how often I want to do it.
If I Choose Weekly from drop down for a activity then I want it to show up in another worksheet of same workbook in it's colomn.
How to achieve that?pls help.