I'm assuming you have 50+ sheets is because each sheet has a unique name attached to it. Why not just create one sheet, one table and add an extra column to hold what is the sheet name? Summing data in tables is orders of magnitude easier than having to deal with 50+ worksheets.
I have 1 Workbook with roughly 25+ sheets. Each sheet is a basic time sheet with 6 entries containing the data as listed. I am wanting to make a Totals Sheet that will Total data per the appropriate accounting Code# 1 thru 10. The formula would look at all sheets current and future, compile totals in the same format as listed per each accounting Code#.