Populating cells: Working in multiple worksheets
 

I have a order form with products listed on Worksheet 1 (10,000 rows of
items). Once users have selected and placed a quantity amount of the
requested items, I would like to have just rows where a quantity is present
on Worksheet 1, to be reflected on a new worksheet (Worksheet 2); inclusive
of all of the information in the relative row from Worksheet 1. Once
Worksheet 2 has been populated, I would like a cell to total the order
amount. I am not sure how this is done and would appreciate any help
available.
--
Thanks...Nina