EXCEL duplicate rows

should the solution is in two files, either the worksheets are identical strings, they need to find and delete duplicates,
that is, in the course of the month generated, once a week, new rows are added, then at the end of the month comes the final file the same with