macro insert three columns repeatedly with all values based on multiple sheets

[KalilMe]

hi
I have many sheets contain data and values for sales and purchase
in sheet report has also data . what I want insert three columns with the same borders and formatting contain (PURCHASE,SALES,BALANCE) and summing the values for SALES , PURCHASE across multiple sheets and put the values in sheet REPORT in COLUMN SALES & PURCHASE . the COL BALANCE should add the formula as I put in sheet CASE1 when run the macro from the first time but when I run again . the formula will be change as I put in COL BALANCE in sheet CASE2 and somtimes there are some a new items in all the sheets except the sheet REPORT then should add it as I highlighted in sheet REPORT . when get the values after summing the values across sheets should match COL B,C,D toghether and when add a new items in sheet REPORT should match COL A with the others sheets in COL A
NOTE: the sheet CASE1,2 just to understand what I want . the result should be in sheet ORIGINAL and the formula in CASE2 it will continue every time run the macro .

[KalilMe]

any help?

[KalilMe]

issued in another forum
https://www.mrexcel.com/board/thread...heets.1180163/