Finding duplicates across worksheets

[JimDandy]

How can I identify duplicate records across worksheets? I have a spreadsheet that has 3 worksheets. Each worksheet contains multiple columns of data. one column in each is labeled Name and occasionally, the value in the Name column in one worksheet is the same as a value in the Name column in another.

What I'd like to do is to run a macro that can identify the duplicates between all three worksheets and to copy the duplicate records to a new worksheet.

[JimDandy]

Anyone? Is there a function that can do this, a built in utility?