how do i look through worksheets in a workbook to find duplicate

I have 5 worksheets in a workbook. I need a formula that will look through
the worksheet for duplicated information and display in another worksheet.