how do i add up the same cell from multiple named tab sheets

P

Paul

I need to add the same cell from multiple different named tabs into a report.

and many times

any ideas short of "sheet1,a1+sheet2,a1+.........
 
Top