copy data from multiple workbook and sum & subtracting among columns

hello

i have two files every file contain two sheets(import & export and my file destination is inventory i would bring data based on select l2 then sum and subtract among e f,g,h, i put the formula in col i to understand it for more explanation inside file

thanks in advance

I know my demand is huge but I hope somebody help especially the experts

thanks

it has published in another forum

https://www.mrexcel.com/board/…ng-among-columns.1156036/

where I find this part ,is it in my account?