Running totals from timesheets

[dd]

Please help;

I have an excel timesheet template covering the activities of a group of
people.
The activity names and personnel names in the table do not change.
A new file is created each week and the filename is the Friday and the Month
i.e. 1512.xls (15th of December)
I want a new workbook to provide totals of time entered against each
person/activity(as hours) in each file.
I want the file to be live so that it updates as new timesheet files are
created.

I would envisage it as being the same layout as the weekly timesheet, only
it would show overall totals. I don't know how to bring in these totals from
the external workbooks, or how to keep it 'live' as new files are added.

Thanks
D Dawson
Scotland

 

[dd]

I assume from the lack of response that this cannot be done. Okay, lets try
it another way. What if the sheets were within one workbook?

DDawson

Further information/description of my problem...

In a new excel file, how do I:

Get excel to go through each xls file in a folder
Get the values of each cell, in the range A1:G10, in each file, Sheet1
Total the values of each cell, in the range, in each file, sheet 1
Provide the totals of each cell, in the new file, in range A1:G10

Any help on this would be appreciated

Regards
Dylan Dawson
Scotland