Transferring data from multiple sheets in workbook to one sheet

[BillB]

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? Thank you.

 

[Alojz]

Bill, make ur deeper research on 3D pivot tables. In Excel 2007 this is what
might be ur choice. There is nice guide how to process directly in Excel
help. U need to use pivot table wizard (different icon from the one in
Insert->Pivot Table) which u can add to quick access toolbar. Select all
commands, find pivot table wizard and place it to ur quick access toolbar.
But I do not know whether 3D pivot tables are supported by previous Excel
versions.