Removing duplicates

The first sheet represents workbook 1 which would be todays enquiry
The second sheet represents workbook 2 which would have all prior enquires
The third sheet is what I need to end up with after copying the contents of workbook 1 into workboook 2 and removing duplicates based on afore mentiond criteria.

Many thanks for your perseverance.