Criteria matching?

I am trying to accomplish some type of number matching within Excel. Here is what I am trying. We have several parts that make up a finished part. If I put in the finished part on sheet one then I would like the part numbers that make up the finished part to be filled in the other sheets. Is this a possiblity? I would like to be able to have the operators fill in the fron page, and then the rest of the sheets to be filled in automatically. We don't have that many finished parts, so there shouldn't be too much to code if this works. Thanks for any help!

Not sure about Excel, but in Access this would be a simple query at most.

Set up a lookup table and use =VLOOKUP() ?