Copying rows from another worksheet

What im looking to do is automatically populate sheet2 from the data in sheet1. I need all the rows that contain any data in column "C" to appear in sheet2.

sheet 1
A B C D
1 v 1 2 3
2 w 3 6
3 x 7 5
4 y 9
5 z 6 5 7

sheet2
A B C D
1 v 1 2 3
2 x 7 5
3 z 6 5 7
4

In E1, Sheet1 enter:

=COUNTA(C$1:C1)

copied down

and in F1, enter =MAX(E:E)

Then in A1 of Sheet2:

=IF(ROWS($A$1:$A1)>Sheet1!$F$1,"",INDEX(Sheet1!A$1:A$5,MATCH(ROWS($A$1:$A1),Sheet1!$E$1:$E$5,0)))

adjust ranges to suit and copy down as far as you want and across...

To hide zeroes, go to Tools|Options and in View tab uncheck Zero Values.