How to consolidate data from different files containing many sheets to a another file...

[erkamu]

Dear XLS masters,
I need your help.
I have 5 xls files ("file1", "file2"..."file5") each of them containing 52 sheets named "W1", "W2", ..."W52"
Now the point is that I want to consolidate particular data in one another file named "common" that also contains 52 sheets:
Example: File "common", sheet"W1" cell A1 to sum cells A1:T1from file 1 sheet"W1"
File "common", sheet"W1" cell A2 to sum cells A1:T1from file 2 sheet"W1"
File "common", sheet"W1" cell A3 to sum cells A1:T1from file 3 sheet"W1"
.......
File "common", sheet"W1" cell A5 to sum cells A1:T1from file 5 sheet"W1"

The same should happen for all 52 sheets...

of course I can do it sheet by sheet but it will take looong time and efforts.
I believe there is a smarter way of doing it.
What I have tried is to take the sheet name in one cell and then to try with indirect formula to build sum regering to file name and that cell but...I could not do it...
Thanks for your bright ideas!
erkamu

[erkamu]

Please help!!!