IF Statment for pulling data from another workbook and if its not found looks at the next workbook?

[NGB82KS]

I have an excel spreadsheet that pulls all our server logs into 1 location using the following code

ServerName	Total
Server 01	='\\Server01\information\[Server Weekly Report 2021 04 29.xlsx]Summary'!$A$1
Server 02	='\\Server02\information\[Server Weekly Report 2021 04 29.xlsx]Summary'!$A$1

However, the report can be generated anywhere between 1-3 days.
My question is there a way to IF statement that that looks for that file/cell reference, and if not found, will look for the next file date & again a 3rd time, and if it finds any of them, put that result into the excel spreadsheet?

E.g. (=IF(\\Server01\information\[Server Weekly Report 2021 04 28.xlsx]Summary'!$A$1 isnt found, then look here \\Server01\information\[Server Weekly Report 2021 04 29.xlsx]Summary'!$A$1 or here \\Server01\information\[Server Weekly Report 2021 04 30.xlsx]Summary'!$A$1) and whichever file/cell reference is found, puts it into the file?

 

[vw412]

I think you are going to need VBA to do this. Don't have any idea at this time how, but seriously doubt this is doable with formulas.