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