I have a workbook with three worksheets.

sheet1
sheet2
sheet3


Can anyone help me create code to do the following.

Create a new worksheet and name it "Report"

Create a list unique records from column A:A in sheet1, sheet2, and sheets3
and put in Column A:A in the newly created worksheet ("Report"). The
worksheets may have duplicate records so I'm trying to create a list of
unique records from my three worksheets.

Thanks,

--
Regards,

timmulla