Search for duplicates and that have changes and update the changes & delete the past entry

Hello All,
I have a list that I will have to update every day. Sometime columns N, O, P will change with updated status. Columns B, C, D, E, F, G, H, I, J, L, M should all match. If there is any changes I want to have the new changes updated and delete the past entry. I was going to paste the new data on sheet 1 (added to old entries) then run the macro. If it would be better, I can paste the new data in sheet 2 and have it compare to sheet 1. Then replace any entry that have changes to Columns N, O, P or added new entries. I have attached the spreadsheet example. Items with red font were the first entry and the black font is new entries. I would appreciate any help with this. Please let me know if you need additional information. Thank You!!!

I have added what the spreadsheet should look like once the macro is ran on the attached spreadsheet. Thanks