Private Sub not copying/pasting to second sheet

Hello all,
I am new to VBA coding and am having issues with my workbook private sub not completing the tasks I've given it.

I have a log to track the various progress stages of our part numbers (part numbers in column b). the master log has all part numbers, with data including the "condition", or status of the part (this is in column bm).
I would like for excel to automatically run when the condition of a part is changed, and if it is changed to "Active," I would like the sub to look at sheet 2 ("Active") and if the the part number (column b) does not already exist in the active sheet, copy that entire row that has been changed. I would also like this to work dynamically, so if a part number were to change from "Active" to, say, "complete" I'd really like for the code to remove that part number row from the "active" worksheet.

I have looked up various tutorials on class modules, private subs, workbook and worksheet modules, and have tried autofiltering the master data to copy over to the second sheet. As I have it now, the code is in the workbook module as a sheet change. I have both sheets dimensioned and am using the intersect application to determine the range to watch for changes. I try to test the code by changing random conditions, but when I look at the second sheet, nothing has been copied over, even though no errors pop up in my VBE.

here is my current code in the workbook module:

Please Login or Register  to view this content.

I have attached my workbook so that you may see what I am talking about
thank you so much for your time,
Riley

Mike,
thank you so much this works perfectly!! I made a slight change in the formula to fit my needs just a bit better

If UCase(Target.Value) = "COMPLETE" Then

what i changed it to

Please Login or Register  to view this content.

I appreciate your help! I have been trying to figure this out for months and you were able to do it in a fraction of the time!
now, if i have a question that pertains to the same workbook, but does not necessarily deal with this particular issue, should i create a new post?
again, thanks so much
riley