VBA to keep format when concatenating

[isasa74]

I forgot to say that the only thing, if I can dare , that I don't like is:

To investigate merely look from sheet to sheet, row by row, only rows with discrepancies are there.

please this looking from sheet to sheet is exactly what I wanted to avoid with my concatenation rubbish idea!!

my goal (or better to say my dream given my ignorance with the code..) was to have everything at my hand in sheet1 at the very end of the procedure...please