alright, here is the problem... hope you can help

I am trying to create a tracking spreadsheet that will display and calculate information from a ton of different sheets. All of the sheets have the same naming system and are generated from a master template.
for instance, the file for Apr 1 would be at
c:\data\2005\april\april1.xls
there are 6 cells in particular, lets call them values 1-6...

what I need to figure out is not only how to set it up so that I can have all the different cells pulled into a main tracking workbook (with sheets for each month if possible) but also so that it will grab the info in the future without me having to play with the code at all.

I am thinking the only way I will be able to do this is with a VB script of some sort, however I have no idea where to even start.....



any help would be greatly appreciated.