Removing Duplicates across multiple worksheets

I'm taking an excel document given to me, running it through a series of queries in Access and exporting the results out via TransferSpreadSheet into Excel. The problem is some of the records meet the criteria of multiple queries. What I'm wanting to do is have an excel macro/vba go through and remove duplicates from the worksheets.

If possible I would like it to use Column Z for the unique identifer for each record and look through all of the sheets using Column Z from sheet 1, sheet 2, sheet 3, etc and compare them to each other. I found code on this forum but it's not working for me (is probably that I'm doing something wrong)

Please Login or Register  to view this content.

Can anybody help? I've been searching Google all day and am unable to come up with a resolution.

Spent the night looking, I'm unable to find code for this. I'd greatly appreciate any suggestions to help with this.