[MovedGoalPosts]

I have to agree that it does look like something that is best suited to Access. Once you have your various access data tables set up (instead of each different excel spread sheet) then you'll creat a query to append or update data to a the output table, form or report you require. And creating a form for the input data table is easier too.