Referencing "All" other Worksheets, Regardless of Count

[mikaselm]

Hey, All! I currently have a set of google sheets that I'm pulling data from, into excel, for some reports that are being automatically generated.

Basically, my sales guys fill out a google docs workbook with a sheet for each month. It looks something like this

August sheet:

Joe - $10 - 8/5/14
Sam - $20 - 8/5/14
Ned - $10 - 8/6/14

And so on. Then a new sheet for September, and a new one for October, and so on.

I'd like to have a sheet that had all of the information in one big, long, ugly list. I know how to extract the month that I want from one big list, but I can't seem to figure out the reverse. I can get the data there by copy pasting... but then I have to keep copy pasting... I can get it there by reference formulas, but I have to select the sheet manually, so when a new month rolls along, I don't have that data. Does this make sense?

Thank you all so much!

[FDibbins]

See if this thread will help you get started?

http://www.excelforum.com/excel-form...-the-same.html

[mikaselm]

That's pretty similar to what I'm doing now... but it doesn't update when a new sheet is added....

I'm starting to think that the simpler solution is just to have my sales guys put all of their information on a single sheet.

[FDibbins]

OK if the layout on each sheet on each month is identical, you could try this instead...
if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though