update masterfile with data from everyday new excel file with date stamp in name

Hi,

I need to pull data into a master file from a new excel file everyday that is labeled in the same syntax, just with the new date, everyday. How can I go about doing this? Currently I have to update the vlookup with the new date manually. Could you please assist?

Thanks!!

Is this even possible to do?