Linking data across worksheets

I'm sure this question has been addressed many times in different forms. So if someone has a link to direct me to, please help. I have not found anything to explain what I would like to accomplish directly. 

What I'd like to do is link data from a master list to multi sheets of the same workbook. 

Here's the set-up. The master list is an inventory list comprised of part #, type, description, and price. These parts are used in different sheets to catalog inventory for different things. What I want to accomplish is this: I want to link the master so that if I update anything (mostly frequently the price) it will automatically update across the entire workbook. 

I understand I can match cells. However if I update the master list with another part and that adds a new row, this changes the cell destination. 

Ideally I want to create it in a way that revolves around the part number. If I add a part number or change the price of an existing part number, it will update on any other sheet that utilizes that same part #. 

Is it even possible to link multiple columns for the same row. 

  example : 

         part #      type              description         price

        12345,   misc. electric,    on/off switch,    $12.00

If I create a new table on a different sheet and input part # 12345 into one cell it will fill in the  columns in the row with the linked data, that way anytime I update the master it syncs everywhere that part # is used.