Comparing Excel spreadsheets within a workbook

[Robin121695]

I have 2 spreadsheets in a work book.  I need to compare the part numbers and remove the part numbers that are not in both list. Any suggestions on the quickest easiest way?

Thank you

Robin12

[#2]

@Robin121695 

An option with Power Query. Sample attached