Comparing Excel spreadsheets within a workbook

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