I have a workbook with 10 sheets. One sheet is the "master"; initially it is
blank except for the headings at the top of 6 columns. The other 9 sheets
represent 9 categories of products customers can buy. The names for each of
these 9 sheets reflect the product categories. Each of these 9 sheets
includes 10 - 70 rows; each row represents a different product; each of these
sheets has six columns (mfg, part#, descrip, cost ea, qty, total cost).

Starting with all "qty" at zero; the customer would go through each of the 9
sheets and enter the quantity of each product he wants to buy. At this point
I want a copy of all information in a row in which the "total cost" is
greater than zero to be placed in the "master" sheet which would have the
same six columns as the other nine sheets. In this way I can look at only the
master sheet to see what the customer has ordered. Of course, if the customer
goes back into any of the 9 sheets and changes products or quantities, I
would want these changes reflected in the Master Sheet.

How would I do this in Excel 2003 (SP3)? Thank you.