Can you combine multiple excel sheets into one master excel?

Hey so I started working for a company and part of my job and other employees is to input information into an excel spreadsheet that's located on a server. We have encountered a problem in which that when several of us input data into the spreadsheet it sometimes wont save and the data will disappear. We have decided to save the spreadsheet located on the server onto our own desktop and we each input our data and save it again on desktop. Is there a way when we are all finally done inputting the data to somehow combine all these different excel spreadsheets into one master one to be uploaded to the server? By the way, all these spreadsheets are located on different computers. Thank you in advance!

Awesome, ty much!