I"m adding the same cell on multiple sheets to total up on my "total sheet". Is there a simple formula to put on the "total sheet" that will work? I can use ='sheet1'!B1+'Sheet2'!B1+'Sheet3'!B1+etc. The problem is I have 200 sheets and I know there must be an easier way.
Bookmarks