How to cell reference from certain files based on dates

[szakharov7723]

I have daily files that "feed" information to summary file. Right now it is a manual process. (copy-paste)
There are certain cell ranges in daily file that feed information to specific sheet and specific date in summary file.
I want to find a way to make it automatic.
I almost did it with the formula, but excel doesn't let me implement it.
I have created the formula in summary file that identifies which cell to reference in daily file based on date and value in cell:

[COLOR=#333333]=CONCATENATE("=","IFERROR","(",CONCATENATE("'",$B$2," ",TEXT($B33,"yyyy"),"",TEXT($B33,"mmm"),"","[",TEXT($B33,"ddd, mmm dd"),".xlsb]",CONCATENATE($B$3,C$2))&"+"&CONCATENATE("'",$B$2," ",TEXT($B33,"yyyy"),"",TEXT($B33,"mmm"),"","[",TEXT($B33,"ddd, mmm dd"),"_2",".xlsb]",CONCATENATE($B$3,C$2)),",","'",$B$2," ",TEXT($B33,"yyyy"),"",TEXT($B33,"mmm"),"","[",TEXT($B33,"ddd, mmm dd"),".xlsb]",CONCATENATE($B$3,C$2))

[/COLOR]

This formula is used for 3000+ cells
Which results in the following formula as an example for one cell

[COLOR=#333333]=IFERROR('K:\Maint\PLANING\DSC CALENDARS 2019\Apr\[Tue, Apr 02.xlsb]Millright data'!B7+'K:\Maint\PLANING\DSC CALENDARS 2019\Apr\[Tue, Apr 02_2.xlsb]Millright data'!B7,'K:\Maint\PLANING\DSC CALENDARS 2019\Apr\[Tue, Apr 02.xlsb]Millright data'!B7

[/COLOR]

To make this formula work I need to replace "=" with itself. The issue is if daily file doesn't exist yet. It shows the following error and stops replacement process for other cells, even if I make it a macro:

https://ibb.co/TvTfDs7
Is there a way to avoid this popup ? Or any other way to automate this process ?

 

[szakharov7723]

For some reason I cannot see uploaded picture. So just in case describing it here: It is Update Values popup window. It wants me to select the file (I press cancel obviously)