I want to make a worksheet that will summarize the data from two spreadsheets, called “cars” and “parts, and make this third worksheet display only those rows with a quantity of greater than 0. I want to split the third summary worksheet into two vertically split sections, one for cars, one for parts. I need to total the "parts" and total the "cars" sections, and then make a grand total.

I want this to be a dynamic worksheet, so if you change the quantity of a line item in “cars” or “parts”, it will automatically show up in the third summary worksheet.

Does this make sense? I'm sorry if I'm putting this in the wrong forum, but I've tried Pivot Tables and such, and I think this would be a fairly simple and straighforward need, and something that could be done without VB.