VBA Code or Formula(s) for Complex Referencing

[DougK73]

Hello. Here is what I want to do...

In one worksheet, I have a vertical list of unique part numbers in column A where no part number is repeated and each part number is unique. In columns B through K (10 columns) there are other alpha-numeric text in each cell (one per cell) listed horizontally that are uniuqe to each part number listed vertically in column A (see below)

Sheet1

Column A Column B Column C...K​

"PN"
111.2222.333 CF0056-16W-2005T FG5516-23E-5505F...
111.2323.444 BH5560-17R-2332E GH5567-45W-8795G...
123.4545.555 WE1560-20T-336ST QW5587-564-8745R...
.
.

I want to compare the above data in the above worksheet to another list of the same part numbers from another worksheet (Sheet 2) that are also listed in the same cell positions within column A - Sheet 2. The text in the cells in the above worksheet (Sheet 1) in columns B through K would also be compared in a list that has the unique text in one column (column B) listed vertically by part number in column A (see below)

Sheet2

Column A Column B​

"PN"
111.2222.333 CF0056-16W-2005T
111.2323.444 GH5567-45W-8795G
123.4545.555 WE1560-20T-336ST
.
.
.

When the items in columns B through K of sheet 1 match the items listed in column B of sheet 2 for every instance of the part number listed in column A, then return those matching values to a third column B in sheet 3 (a third worksheet) - see below

Sheet3

Column A Column B​

"PN"
111.2222.333 CF0056-16W-2005T
111.2323.444 GH5567-45W-8795G
123.4545.555 WE1560-20T-336ST
.
.
.

Sheet 3 is the summary of the matching results.

Thanks,
-Doug