insert three columns and bring the values based on matching with two workbooks

hello
I have two workbooks report1,2 contains data should match in COL B,C,D with file OUTPUT Also IN COL B,C,D then inserting three columns and brings the values in COL sales and purchase and calculate in COL QTY i need show the formula in COL QTY and it should summing the values from files each COL SALES AND PURCHASE and add to file OUTPUT and if there are brands are existed in files and not existed in file output should add to file output as highlighted by yellow but when add them should match col A in files with COL A in file output and add it before total
note : the files in the same folder and may be increase the files also the data in output is increasable in rows I mean in COL A,B,C,D
I put the result in sheet after and the original data in sheet before but should show the result in sheet1 , and every time run the macro should insert three columns with same borders and formatting also formulas .
if this is not clear please inform me