Workbook with muliple sheets

[rvdsabu4life]

As an excel n00b, I was put into the position of developing a costing sheet for my company.

I have linked the file below.

What I would like to do is on the Master Sheet, have all my information. Then on the subsequent sheets, be able to only enter the part number and then it fill in the remaining columns. I cannot figure out how to do this. Any help is appreciated.