Copying Entire Row of 1 Worksheet to Another Worksheet Based on the Value in 1 Column

Please Help.

I have a worksheet where a large amount of data that is constantly updated. It is a table with some auto formatting applied based on the value entered in Column C. I would like to have Excel Copy an entire row of information from the first worksheet to a second worksheet in the same workbook.

Please see the attached example.

What I want to happen is to have all of the rows that have a "status" (Column C) = 1 (In worksheet "Estimate List")to be copied to the "Vendor Bid List" worksheet. When the "status" in worksheet "Estimate List" changes to something other than 1 it should be removed from worksheet "Vendor Bid List". I would like all of the compiled data in "Vendor Bid List" to be grouped together and separated by blank rows.

I am not sure the best method to attack this, so the easiest method for accomplishing would be greatly appreciated.

Thanks in advance.

Please help.