VBA Macro not working on Network Folder

Hello,

I am calculating YTD Summary based on Monthly file (e.g. JAN.xls) --> Daily worksheet (See attached files)
I need help in VBA Macro. All files are in single folder on my desktop local folder. But When I copy that folder including all files to network folder, it doesn't work.

In Option --> Trust Center --> All Macro settings are enabled and checked. For security reasons I cannot create "trusted Location".

Is there any other way to calculate my YTD summary on network folder?

Please see the attached file for better understanding of mock data are in test2.zip and "YTD summary" file for example output.

Many thanks for your help.