Multi-sheet Duplicate/Exclusive question

Hello everyone,

I have a multi-worksheet question. My situation is as follows: each quarter I get a report in excel format with thousands of sales design win(DW) #'s. I need to perform follow ups with the respective sales reps for each DW. For each report that comes out, it has a big amount of new wins, as well as some old leftover DW's from the previous quarter that I don't want. There is a whole row of values which need to be copied over, but the value I need to base comparisons off is DW's, which are in column B for all worksheets, each one is its own exclusive/original/non-duplicated value.

I want to compare sheet 3 column B (New DW quarterly report) with sheet 2 column B(old/master list of DW), and anything that is exclusive to sheet 3, paste the entire row to sheet 1 and 2, on the end/last row.

Rephrased - every quarter I'd like to be able to paste the new report into sheet 3, run macro, have the DW's exclusive to sheet 3 also pasted on the end of sheet 2(mastersheet) to keep a running total of what I've already done, and to sheet 1 which is my current follow up list.

I have very poor macro skills, my clumsy duplicate killing attempts arent working, and my IT department is backed up for the foreseeable near future. Any help would be greatly appreciated.

Thanks,
Dave

Attached is a sanitized/watered down version