Auto Copy selective rows from one tabbed worksheet to a second tabbed worksheet?

[greg@ghwilke.com]

How do I copy only the rows you fill in with a quantity on tabbed worksheet 1 and automatically copy those rows to tabbed worksheet two without any spaces?
I have a bid sheet that has about 200 rows on Tab sheet number one. I fill in the quantities of about 50 different rows though-out the list of possibly 200 rows. I would like the items I filled in the Quantities to be copied to tab worksheet 2, so I can print only the items filled in.
Does anyone have the formula to do this?

[mohandeck]

Send Sample attachment.

Are you expecting result by formulae or macro?

[greg@ghwilke.com]

By formula

[mohandeck]

Sample file...