A simple setup lets Excel combine recurring reports and refresh the results whenever new files arrive.
Before you learn another formula, check the ribbon.