vba code for automating branch wise day wise amount to summary file

Hi All,

I have a requirement in excel for automating branch wise day wise amount to summary file month wise day wise. The summary file has month wise sub sheets. I need vba code to run for all the months once i input Branch code in Summary file month wise sub sheets.
If any day amount is not mentioned in source file the same has to be updated in summary file for that particular date as zero.

I am attaching requirement files for reference.

Your cooperation in this regard highly appreciated.

Sincerely,
Pranith