Consolidating Data from Multiple Sheets

edited 12/09/19 in Formulas and Functions

Hello, I'm hoping there's an easy way to do this.

I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This client list is identical between all three sheets, if it matters. 

I'd like a single sheet I can look at each month that will pull that month's data from all three sources. What I don't want to do is open each sheet every month, copy only that month's data, then paste it into a new sheet. 

Is there a report I can run that will give me a list of all entries in all sheets for a certain input period? 




Edit: SOLVED. Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!