Extract row whenever it is enetered to a list
 

I have the following list and every day several rows are added to the list.
My reference column is column "c" and I have 8 variable in column "c". I want
to take out rows containing "aa" (or "bb" or "22") in column "c" and copy
that row into the second worksheet, my problem is that I want it to be done
automatically whenever a new row is entered with given reference. a way of
doing that without macros?


A B C D
1 tr re aa fd
2 po rf bb sd
3 hu fv aa cb
4 ty fc 22 tg
5 tr dc bb fa


Reference: "aa"
A B C D
1 tr re aa fd
3 hu fv aa cb