Hi,

This is my first post on this forum.
I have a question to ask regarding summing across multiple workbooks.

I have in a workbook with a summary worksheet whereby I sum up all the values of a cell (A1) in a worksheet called workdata that is in 50 other workbooks. When the number of workbooks was manageable, about 10 I could just open all the workbooks and simply use the summation formula and go to each worksheet in the workbook and sum them all up. But with 50 and counting this become a chore.

Is there a easy way to do it? Please help.