Creating Tables that automatically import data from new worksheets

[nshah1985]

Every month, a Summary worksheet is created (like the DataFormat example I am attaching to this post (file: dataformat, "May2013data" worksheet), this is a consistent format every month, so the cells are consistently located). There are/will be plenty of worksheets like that in this workbook (monthly data from 2010 until now, and adding a worksheet every month). I don't have too much input on the format of this, it's just how the raw numbers are published to us.

I would like to create a couple of auto-updating tables and a number of charts… I have been manually doing this but would like this task to be “automated” if possible (as little interaction needed as possible once the new month’s data has been added as a new worksheet).

SO specifically, this is what I’m trying to do:

At the beginning of every month, I will pull the number for the previous month, and paste them into this workbook as a new worksheet, which lets say is named May2013data . Every month can be like this (ex name them June2013data, July2013data, etc). Once that has been pasted into a new worksheet, I would like the data tables (called "summary" in the example workbook)) to expand to include the new month, and pull the data/totals as indicated. After that, I would like the to "automatically" update some charts also, but will worry about that after I'm able to get the data summary table going first.

Any help/assistance is much appreciated, thanks for looking in to this situation!

[nshah1985]

any ideas?

I tried doing this by formulas but I couldnt make it automatically include data from the "new" sheet every month... I was hoping a VBA or macro could accomplish this

thanks