Combine worksheets into a master sheet

[smbsvcs]

Morning,

I am a newbie to Excel in many ways

I have a question you can answer, I'm sure

I am trying to 'automate' an excel file for project estimating
I don't even know enough about Excel to know which function I should use

HERE IS THE SCENARIO

There are multiple sheets.
Each sheet is used for a specific assembly of building components (boxes, pipe, wire, circuit breakers, etc.)
Not every assembly will be needed for a given project, some will have a quantity value of zero
IE: you may need only 2 types of boxes, but there are 10 different types listed.

At the bottom of each sheet is a summary list using the SUMIF function
I am using VLOOKUP to populate the remaining data columns from a Master Stock List for catalog #'s, etc.


HERE IS THE QUESTION......... if anyone is inclined:

I would like to find a way to copy values >0 from the individual summary lists, on different sheets
I would like to copy those values to a separate sheet
The goal is to create a list of materials to be ordered for that project

What function should I be using?


BACKGROUND:
I have been doing this manually
By automating this function, it eliminates the 'ID-10-T' factor (commonly known as human error)


anyone willing to help?