Excel Expert - Rollout/Master Sheet

I work for a commercial real estate development company and we are trying to work on a project rollout sheet that can be one master sheet. We need to input data from multiple excel sheets into a master spreadsheet. We also would like it to automatically update the data as we edit the other sheets that it's linked to.