Hello. I have a summary sheet that needs to add all the same cells from 80+
worksheets. For instance, on the summary sheet (cell d6) I want to add all
the amounts in cell f9 (from all the other worksheets). I've attempted this
and the formula bar takes up half the screen when I'm on the actual cell and
it's also saying the formula is too long to add up the remaining tabs. Any
shortcut to this?

Thanks!