Hello,

I have one workbook which is considered a template to workbooks that input
data into daily and save it based on the current date. For example
WorkbookA040106, Workbook2040206, etc. The workbooks are added daily based
on the current date. I would like for one main spreadsheet to give me the sum
totals of the data that is input into each saved workbook daily whenever a
new file is added. Is this possible to do? If I saved each individual
workbook into a folder is there a formula or a macro that can be created that
would look for a new file and add the data for each workbook in the folder to
themain workbook when ever a new file is created? This would be done once a
month. These files would need to remain in the folder for individual data
results but I also need month to date data results