Im currently working on a new excel template inserting how many hours each person has worked on a specified place, well its not really a advanced template.

But they are divided in weeks and in each workbook there is a weekly sumary, this works great but the thing we are trying to work is having one Workbook taking all these sumarys from all files in a folder and put it together into a "Total".

I've got the info when specifying the workbooks one and one but is there a way getting the info from all workbooks in one directory? (different names but same template) ((like if you using *.* for example))

//Tobias