Summing across multiple workbooks

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.

In the summary workbook use a formula such as =Book1!A1+Book2!A1+Book3!A1 etc to total the values for you. You will need to replace the "Book1" etc with the names of your workbooks

Thanks for the suggestion. This is what I am doing and it really tedious going through 50 workbooks and counting. What I wanted is to know if there is a better way either using VBA or otherwise.