Filtering, querying, visualizing, and editing: these tools do the lot.
A simple setup lets Excel combine recurring reports and refresh the results whenever new files arrive.