Sum Question

D

DVan

I have 50 worksheets, all with the same structure. I want to create another
worksheet that adds up all the sheets. Is there a quick way to do this
rather than using =(Sheet1!a1 + Sheet2!a1 + Sheet3!a1)

Thanks
 
Top