How to summarize several different worksheets in Excel into a single summary table

Excel multiple Worksheet totals

A to create a summary table, select the cells below the number.

(B) Click on the data-combined calculation, the function fill in the sum.

C in the reference position, click the box with the red arrow.

D Click on Supplier A to select the range of data involved in the calculation.

E Click Add at all reference locations to appear "a supplier!" $D $ $D $ ", and then work on Vendor B worksheets and C vendor worksheets in turn.

(F) Finally select "Create a link to source data" and click OK.