I have 50 (or so) worksheets and I have created a 51st as a summary page. I
would like to total cell C20 on all 50 pages on the 51st. The problem is
sheet names are too long and I can't a formula big enough to accomplish this.
Is there a way to use VBA to get around the formula length constraint and
total all C20 cells on my summary sheet?

thanks in advance!