Extracting non matching records to a new book

Hi there. I have had a search and there are similar requests to my problem but not quite exactly.

Basically I have 2 reports in 2 separate workbooks, week 1 and week 2, listing holiday properties.

Anything that appears in week 1 but not in week 2 can be copied into a sheet in another workbook called Data and placed in the "To Delete from Database" sheet.

Anything that appears in week 2 but not in week 1 can be copied into a sheet in the Data workbook and placed in the "To Add to Database" sheet.

I did hope there would be some Advanced Filtering option or Formula as I don't really know any VB.

I have added a basic sample but feel free to ask me to expand.

Thanks for your help.