Hi,

I receive 4 workbooks every week, each of which holds 7 worksheets; sheet 1 through to 7. The layout in each sheet number matches (i.e. sheet 1 is the same layout across each workbook, sheet 2 is the same layout across each workbook etc) but differs between numbers (i.e. sheet 1 doesn't match sheet 2). With me so far? Good.

What I want to check is that there aren't any duplicates for the sheet numbers - so sheet 1 in workbook 1 can't match sheet 1 in workbook 2 or sheet 1 in workbook 3 etc etc...

Is there an easy way to check that two sheets are the same?

Thank you!

jonnya