title: Merge multiple tables
body: <p>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:</p>
  
  <p><a href="https://i.stack.imgur.com/DJOvo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DJOvo.png" alt="Merging tables in Google Sheets goal"></a></p>
  
  <p>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).</p>
  
  <p>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.</p>
  
  <p>Pivot tables do not permit to achieve this kind of gathering on several tables.</p>