We are confident that after following the step-by-step process above, you will be able to obtain all values from all tables. However, you may still wish to compute the total of all the numbers, not just list them.
The solution here is easy. Click on the cell where you want to show the total value then type in the Formula bar =SUM(E3:E6), where E3:E6 is the range with your values, and press Enter.
How to Summarize All Values in the Table