Updating values in an excel file with data from multiple excel files

Hi all,

i'm new here, and i hope someone can help me. The problem is that i have a file with thousands of rows, and a couple of dozens of columns, that needs to be updated everyday with data from 2-5 other excel files. is there a macro to do this update using the Date (today date) as criterion? i attached some test files, to see what i'm talking about. thanks.