I am making a bill of materials at work and have a master list I want to
access from other sheets.

The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
other sheets.

I have tried pivottables but I am having issues showing the data in it
original form:

Part Name Quantity Material Expense Category etc.
(accross the row)

I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.

If you can help.
Parker Jones