Hi there

Please help. I have 43 different workbooks, each containing 9 named
worksheets ie toys, carrots, flowers and cats containing about 11 columns of
information.

Basically I want the totals of "column B" on worksheet called "toys" in the
43 workbooks added up.

I can put all 43 workbooks on one workbook if thats going to make it easier.
Unfortunately the totals arent all in the same cell.

Any suggestions?