Worksheet Change - need to ignore target cell in results

Hi! That's probably a kind of confusing title, but I'll try to explain.

I have a workbook with 19 sheets in it. Twelve of them are for each month of the year and there are 2 others that need to be included in my macro ; "Add Dept" and Import & PJ".
When a user types a number into a cell in column F of one of the months' sheets, I need the Worksheet Change Event to look in the rest of column F in that sheet, as well as column F in the other monthly sheets and column E in the other 2 sheets. If the number that was just keyed is found in those other ranges, I need a message box to pop up showing all of the other cells that have that number.
I have a macro that does this, but a message box pops up even if that number isn't located anywhere else and the box shows the cell that the number was just keyed into.
I need it to not consider the "just keyed in" cell a match.

Here is the code I have now. I've studied and studied on it and tried changing NUMEROUS things and I can totally break it so it doesn't work at all (LOL!), but I can't make it do what I'm asking.

Please Login or Register  to view this content.

Also, if someone could explain to me - in non-tech terms - what each part of the bolded section does, I'd be forever in your debt! (I have an idea what some of the lines mean, but I wouldn't swear to it)

Thanks

Jenny

Please Login or Register  to view this content.

This should fix your problem

Please Login or Register  to view this content.

submit your workbook

It worked just fine for me when I tested it on your workbook.