Subtotal in each worksheet, and then total in the summary table, =SUM(SHEET 1! B 100，SHEET2！ C50，SHEET3！ D60). (Subtotal of different locations).
Subtotal in the same cell is easier = sum (sheet 1: sheet5! C 100), add up the data of C 100 in five tables. I wonder what your watch is like. We can discuss it.