Should I use a Pivot table?

[keith1955]

I think I need to create a Pivot Table but not sure way to do it and would appreciate some direction please for the following:

• I have a separate Excel sheet for Qty 5 x sites that have different Equipment lists. 
• Each Item has a Unique Part Code
• I need to  give a value against each Part Code
• I have a master sheet with all the different Part Codes and Values
• Using the master sheet how can I populate a value in a cell against the Part Codes in the 5 separate site Sheets.
• I will be adding more sites and changing equipment in the sites as designs change

[#2]

in the 5 separate site Sheets.

I guess u need to consolidate 5 sheets to one sheet before further analysis.

[#3]

Thanks but I do not think that is best as I need to present each site as a separate equipment list with values (or costs). That change as assets are added or disposed of. I was just trying to see if there was an easier way of pulling the costs from the master sheet into each separate site sheet using the part codes. I can obviously type = in each cell and highlight and enter against each individual price on the master sheet. Just thought there might be an easier/quicker way of doing it :)