Easily merging multiple sheets into one comprehensive sheet

edited 12/09/19 in Smartsheet Basics

This may be a very specific problem but I appreciate any help! 


I am collecting a certain set of data from people and what I would like to do is provide an Excel template for folks and once they return the template, upload their data into Smartsheet. I know that any import creates a brand new sheet. But I'd like all of the data to eventually be compiled into one sheet so I can compare their data. 


Is there an easy way to do this? I hope my explanation makes sense, thanks again for any help in advance.