Macro for arrange worksheet

[john5599]

I have an excel file as the sample file share link . I would like to have a macro for arranging the shee1 to sheet2. Then I want to compare the sheet2 with another workbook named book1 sheet named Data1 for Invoice No, Item Name, and party name. If work book Data1 don't have such records then append these records under the same column names in Data1 worksheet. I am expecting I have record a macro there with sample file


https://www.dropbox.com/s/5ykvgwcyi6vsogx/sale.xlsm?dl=0