Copy certain cell values from one sheet to other by filtering or match

[ppminj]

Hi,
I have list of columns for Names (Column 'A'), Numbers (Column 'B')
and Status (Column 'C') in Sheet 1.
I need to filter the Numbers based on value on Column 'C' which is the
Status column. As soon as the value in Column 'C' becomes equal to
'SEND SMS', excel should copy the corresponding Numbers (from Coulmn
'B') and Names (from Column 'A') from Sheet 1 and put in Sheet 2. The
values in Sheet 1 should be copied only and not moved.
I can do the same by filtering the Status Column 'C' by value 'SEND
SMS' and copy the result in Sheet 2 manually, but I want this to
automated by macro or some existing excel funtionality, since I will
be working with lot of data.
The scenario is depicted as under

(Sheet 1)
Name Number Status
Sando 123 SEND SMS
JMJ Province 125
M Clarette 127
Rubanandan 129 SEND SMS
Philomena 131
Cluny Nivas 133
Ruby 135 SEND SMS


Now Sheet 2 should look like
Name Number Status
Sando 123 SEND SMS
Rubanandan 129 SEND SMS
Ruby 135 SEND SMS

Any help is greatly appreciated as I am new to macro or excel high end
formulaes.
Thanks in advance.
Pawan