Common Part Numbers on BOM

I have many many worksheets within an Excel file. Each one contains a list of components used to make a final product (assembly). This is called a BOM or Bill of Material for anyone that doesn't work with this. Although the concept of finding commonalities would be the same no matter what it is.

I am trying to determine what common components are used between all of the final assemblies to ultimately create a kit that would include these and reduce the amount of time the assembler needs to collect all of these when they get an order.
Is there a way that I can pull this data out of these worksheets? Note: I pulled these BOMs from an Access database that I created as well. I do not know VBA or specific expressions that would do this although it seems that this should have been done before?
Anything will be appreciated.