Linked workbooks are a database in disguise, so it's time to treat them like one.
A simple setup lets Excel combine recurring reports and refresh the results whenever new files arrive.