I did something like that before.
I had 4 table and I wanted to do summarize for all tables in one table
and I did like the below picture , I made summarize for each table then I did final summarize for merged table.
but all table had same fields that I used in summarize. This is important