Merging data from multiple sheets



I have over 100 smartsheets with the exact same columns and questions. These sheets have been sent out to leadership teams across the country. I need to combine all this data into ONE summary sheet.

Is there a way to do that? I do not want to link EACH cell to hundreds of sheets.

let me know if there is some magical merge tool that I am not aware of. :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!