Hi sir,
With your example, I don't think we need VBA. We can use some of Excel's new functions like LET, FILTER, UNIQUE, combined with Data validation and OFFSET to create a dashboard to send to your customers without the need for VBA. This will give your customers more peace of mind about security as the file will not contain macros.
Here is a simple formula I have written. Please paste it into the "Difference" sheet and see the result:
=LET(ssid,UNIQUE('Master file'!$B$5:$B$13),Mcur,SUMIF('Master file'!B5:B13,ssid,'Master file'!C5:C13),Mhis,SUMIF('Master file'!$B$5:$B$13,ssid,'Master file'!$D$5:$D$13),Icur,SUMIF('Imp log'!B5:B13,ssid,'Imp log'!C5:C13),Ihis,SUMIF('Imp log'!$B$5:$B$13,ssid,'Imp log'!$D$5:$D$13),CHOOSE({1,2,3,4,5},ssid,Mcur,Mhis,Icur,Ihis))
Additionally, I can also code in VBA if you need it.
I would be happy to work with you.
Thank and best regards,
Hung Tin.