Merge multiple tables

I have lots of sheets describing different kind of expenses and gains of my small company, and I find no easy way to merge my tables like in this example I made:

I want the last table to be auto filled with the lines of the others tables when I update them, so I can foresee the expenses and gain in time (by ordering the green table automatically by date ascending).

By now the only temp solution I found is to copy references to the other tables lines (yellow and blue) in the merging table (green) in advance.

Pivot tables do not permit to achieve this kind of gathering on several tables.