I have a number of spreadsheets in a folder which are all exactly the same called test1.xls, test2.xls, test3.xls etc.

Within each spreadsheet are 3 tabs. All the tabs are identically named and the first tab is replicated throughout all the spreadsheets.

What I am trying to do (but failing miserably) is to find a way of summing the first tab in each spreadsheet into a single tab on a central spreadsheet.

For Example:

test1.xls (TAB1)

Column A Column B Column C Column D
19 22 01 16
18 21 12 32

test2.xls (TAB1)

Column A Column B Column C Column D
32 25 41 01
10 05 12 02

test2.xls (TAB1)

Column A Column B Column C Column D
05 21 49 17
19 15 02 21


SUMMARY.xls (TAB1) - this tab will sum all the cells from the above examples and keep the formatting the same:

Column A Column B Column C Column D
56 66 91 34
48 41 26 55

Any suggestions please?

Mav