VBA and Excel: total referring to first column

[Nelson78]

Hello everybody.

I've a situation like this: the same table replicated three times, I need something that allows me to produce the global result (per day and total) in the last table.
Consider that the lenght of tables is variable (tomorrow I will have for each table one more row with the date 14/11/2018).

How can I manage this?

Thank's.

https://imgur.com/a/IkaUpZo

 

[Trevor G]

Make the three tables data tables and name each one, then create a pivot table from the 3 tables, all you will need to do then is refresh the pivot table for updates or set the pivot to refresh once you open the workbook.

 

[Nelson78]

Make the three tables data tables and name each one, then create a pivot table from the 3 tables, all you will need to do then is refresh the pivot table for updates or set the pivot to refresh once you open the workbook.

Maybe.
Now I'm trying to build a dictionary (so far unsuccesfully...).