Consolidating data from multiple tabs and spreadsheets from multiple users

Hi all!

New to this forum and a pretty novice excel user. I actually work in HR but trying to increase the usage of data analytics in my company and so I have A LOT to learn! Right now, our HR team is trying to track the daily questions/issues they encounter and have to spend time on that really should be directed to other departments (thus limiting the time to do their actual job). My goal is to have a summary sheet that auto populates (Totals tab) that is hidden from the person filling out the form, but so that at the end of the week I can get the summary sheets from each person and then compile those into a Master Tracker to show a summary (that contains other system related items) of the time spent on the various questions or issues that an HRBP would be working on through out the course of a week, month, etc.

Please let me know if this does not make sense or if there are questions. I would greatly appreciate any assistance in automating the compiling of this data as it is very very time consuming right now!