Hopefully someone here can help, or at least give me a starting point, as I'm a bit lost as to how to do this.

I have 2 workbooks, each with 9 sheets. I need to merge the 2 workbooks (I can figure that bit out myself - I'll do it manually if need be).

The problem is then that there are likely to be duplicate entries across all 9 sheets (i.e. an entry on sheet 1 could have duplicates on sheets 3 and 5).

What I need to do is find these duplicates, and then move them so that they are under the original entry (and also delete them from where they originally sit)

Hope this makes sense, and that someone can help.