Hi, I have a list on a worksheet, "sheet4", that I'd like to compare with filtered lists from three other sheets -- "sheet1" "sheet2" and "sheet3". What I need to do is write a macro that compares each list against "sheet4," one list at a time, and then pastes any matches onto a new list on a new worksheet, "sheet5," under the heading "sheet1" (or whatever worksheet is being compared). Each worksheet being compared needs to have its own list on "sheet5".

I've been trying to do this for a couple of days and am now thoroughly confused. Has anybody done this or know how to do it?