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!




Hi Dajah,

You can create a report for that, and that would be my suggestion.

Do you need help to create the report?

Hope that helps!

Have a fantastic day!


Andrée Starå

Workflow Consultant @ Get Done Consulting