Create a living excel sheet for a production roster

We currently have a lot of excel sheets we update with the same information I want it all to read into one master sheet. the documents are updated daily and by different people so I need the main page to record and show the up to date numbers needed. on the other tabs we would need to keep record of the employees, such as name shift department we also need to be able to separate individuals being paid hourly and salary.