I need to copy rows which have same information in column C into another sheet.

For ex:

1 12 P
2 15 NP
3 20 AVG
4 25 NM
5 10 P
6 13 NP
7 16 P
8 12 NM
9 23 NP
10 35 NP

Now I need a macro so that in sheet 2 all rows which contains P should be there, sheet 3 all rows which contain NP and so on.

Please help me