lookup Multiple lists with unique part numbers for total quantity

Hi

Really sorry if this is a basics question but it has me fuddled??

I have multiple sheets containing lists of parts with a unique part number and a quantity required which I want to match against a complete list of all parts on a different sheet to give me a total quantity for each parts.

I presume I need to use a vlookup or match function but not sure which or how?

I have attached a simple example


Any help greatly appreciated

Thanks for your reply, could I not have the table on it's own on the total sheet


I want the users of the file to only update and see the parts 1, parts 2 etc sheets and the total sheet to show just the combined total and use this as on ordering sheet

one input sheet would be great but for a couple of issues

There are 10000 parts in the total list so would be very time consuming for the user to scroll the total list
Each sheet may have 300 parts on it of which 50% maybe be needed

So I need to keep the user interface for adding the quantities as simple as possible

Ok sorry i'm probably not explaining this very well

"Parts 1" would be a list of parts needed for example all materials for house 1 (Plumbing works)
"Parts 2" would be a list of parts needed for example all materials for house 1 (Electrical works)
"Parts 3" would be a list of parts needed for example all materials for house 2 (Plumbing works)
"Parts 4" would be a list of parts needed for example all materials for house 2 (Electrical works)
"Total" would be a total list of parts needed for all works derived from all the parts lists

There could be Over 10 "Parts" sheets which I could format with estimate quantities as a template ready to amend to the specific job
The "Parts" sheets can be kept as a record of which parts are used/needed for each section of the project
When the person inputting the quantities is working on a parts list he is only looking at a smaller list of parts that would be needed not the entire list

Hope this helps