Seems simple to me but I can't pull it off!!!

I'm trying to have my spreadsheet return the text value of sheet 1, column
A. Only if there is a value in column C.

Sounds easy enough but I have 30 value's on sheet one that need to spread to
sheets 2,3,and 4 which only have room for 10 values each. Is there a formula
that will allow me to search the 30 rows in sheet one and return only the 10
which contain a value in column C