one wb with several sheets containing a template for each product
Each template has three columns item#(empty rows) description(several
rows)and required quantity(empty rows). Description contains several
rows. This is a key factor
Since description is general you need to keyin the part# in the
required item. Example Screws are a general description but to order a
screw you have to look at the price list (the last sheet ) and pick the
correct screw and keyin the the item# and required quantity.

So, after you fill each template with the required items; you end up
with a list in each worksheet with partially completed lines.
Completed lines are lines that have the THREE fields Filled.

I need to create a summary sheet that contains ONLY the filled lines so
I can perform a Pivot Table on the filled lines.

Can you help me out