Add Named Ranges To Multiple Workbooks Using VBA

[Stalker]

Good morning Happy Campers,

I have timesheets in work, where i created basic formulas to display times & worked hours etc.
I also have named ranges on 4 of the sheet.

The sheets are named as the department (area 1, stock control etc.)
All the sheets are identical in terms of layout, only the names of staff and hours worked are different.

When i created them, i tried to be pro-active and created flippin loads, through to October this year lol.
Problem being i created a Summary sheet for each workbook, which in short takes all names from all areas and collates them on the last tab, puts Mon-Sun across the top, enters the hours into the relevant days, merges hours worked in different areas and also splits the hours worked over each day.

Everything is working flawlessy.

Except, the above evolution of the sheet was done after i mass created the timesheet, and as such i need to manually open each sheet, set the ranges and name them, add a summary sheet, add the macro, save and close.
So, my request is this:

Is it possible to create a macro on book1, that when i open however many other workbooks (the actual timesheets) the code woould set and name the ranges for me?
The time sheets are all named according to the week -> 'W.C - 08.04.2013', 'W.C - 15.04.2013' etc.

I would be incredibly greatful if its possible!
Stalker