Consolidating Data from Multiple Sheets
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
Check out the Formula Handbook template!