I have approx 20 workbooks whcih are set up identically.

I need to add the data per cell ( eg A1+A1+A1 etc) in a summary workbook but
because of the number of workbooks it's unmanageable to simply add each cell.

Is there a simple way of doing this using "SUM" or whatever?

Thanks for any help