I want to be able to each day add a list of addresses in column A. In column B there will be a date. Each spreadsheet in the workbook will be a different day of the month. I will be adding new address into a new spreadsheet in that workbook as the days tick on.

What I want to be able to do is for Excel to find a duplicate address and return that address to the first spreadsheet in the workbook along with the corresponding date.

Can anyone please help with this?