I basically need to be able to find and highlight duplicates across multiple
worksheets in a workbook. The highlighted duplicates must be written out to
a different blank worksheet.

I would also like to know from which worksheet the duplicate is found in.
All the data I want to compare are in columns C and D. There is another
condition that needs to be satisfied. Only compare the rows in columns C and
D when the value of of the cells in column E is "Y". There are quite a few
worksheets.

Can anyone help.

Thanks