Help! Is this possible??

Hello- I would like to set up multiple sheets within an excel workbook where people can go to their tab and input data and then have that data transfer to a "totals" sheet also within the workbook. I...