I need some help and guidance. I have multiple tabs for different equipment. I have a number of data tables for orings, bulbs, bearings, etc.. that are on each tab. Within these data tables is a description and part#. I'd like to cross reference all tabs(equipment) to count how many bearings, orings, etc there are in common and show up on a summary tab.

For example: I have part description "a" part# "1" on one piece of equipment and the same part on a different equipment (different tab). I need the summary tab showing the description, part#, and a quantity of 2.

Any suggestions will help I'm sure. Thanks