Referencing and updata master sheet at set intervals

Hi Guys,

In a previous post, Proton Leah helped me to get a code running on my sheet which would pull a month's worth of data from individual spreadsheets, sum the values, and copy them to a master sheet..

Please see the post for sample files.. http://www.excelforum.com/excel-gene...ml#post2195667

I now need this to be adapted to log my ongoing historical data.

I need the code adapted to simply look at the Previous day's workbook and record the totals then paste the totals into a new column on the summary sheet (column B) and label the column witht he relevant date. This needs to be repeated every day at 01:00AM.

many thanks for your help, please visit the previous post for sample files and a more thorough explenation of the file structure etc.