Updating active/inactive part numbers tables from 2 workbooks

I could use some help.

I am working on a vba project where I have to update a table that contains part numbers. Some of these part numbers are inactive and need to be deleted/highlighted from the worksheet. I have another worksheet that contains all active part numbers and that is how I determine what needs to be deleted.

Worksheet 'X' needing to be updated: Column D contains the part numbers (active & inactive). I want to make a button that will loop through each cell in Column D, make sure the cell part number starts with D9 then remember that content. Once that part number is found in column D I want to search worksheet 'Y' that's in another workbook. Worksheet 'Y' contains all active part numbers in Column A. I want to loop through each cell in Column A until the part number we got in worksheet 'X' column D is either matched or not found. If there is a match then I want to restart the loop and move to the next cell in Column D. If there is no match then I want to highlight the row of that part number to look at at a later time and then continue to loop through until there are no more rows to search.

It has been a while since I have coded so any help is appreciated.