One selector can replace a stack of nearly identical Excel reports, while FILTER handles the changing results.
A simple setup lets Excel combine recurring reports and refresh the results whenever new files arrive.