How to delete / delete repeated lines comparing different cells?

I want to know how to delete a line that is repeated throughout my table. The image below may help

Possible solutions:

1.

• Scroll through the Macro of file Excel1 to pass the data to the file Excel2 .
• Avoid inserting in the file Excel2 the line that contains the same information already inserted.

In this solution I thought and created a Macro in the Excel2 file by traversing all the lines and comparing its cells. But I do not know if it's the fastest way.

2.

• Restrict the Excel1 file from sending repeated data to Excel2

Thank you!