OK, this is a strange request I guess but I want an excel worksheet to have the ability to remember or recall a value from a previous workbook. What I mean by that is I have workbooks that are saved automatically by there sheet names. I have several of these sheets per day saved under folders named for when they were opened but with the time appended to each one after the original. For example. First saved files of the day are saved in a folder called product under a folder named by today's date.

(c:\10-21-2006\product\production.xls)

The next ones are saved in a folder called product_12_46 under today's date

(c:\10-21-2006\product_12_46\production.xls) and so on.

This goes on for the remainder of the day. Now here comes the problem. I want the totals of the first production.xls sheet to be added to the second production.xls and that total added to the third and so on.

Any ideas? I'm kinda stumped on this one...

I'd be happy to elaborate more if the above is not clear.

The time appended is in military time and I am using Excel 2003 on windows XP.