Delete from 2 sheets if matching criteria

Hi All,

I'm looking for a Macro that will allow me to take information on two different sheets in a workbook, and delete out lines that match based on a "concatenate" formula. Each sheet has slightly different outputs as they are reports from two different systems. Based on the attached example, I'm looking for something that will allow the following:

1) Sys 1 RPT will concatenate columns A, E, F.
2) Sys 2 RPT will concatenate columns A, D, E.

The Marco would then go through the two sheets and delete out lines in which rows with matching concatenated data string matches leaving each sheet with only rows that need to be looked at in more detail to recon and find out why they are not on the other report.

I hope this makes sense, and I'm open to other methods, if there is something easier to work with.