Consolidating many tables from one sheet to a master table including all the data

Hello Dear,

I have this account payable worksheet where I record my monthly payments daily, each day in a different small table, but in the same sheet. And I would like to consolidate all the transaction/table by each day from each table in a big/master spreadsheet for the all month, like a bank statement, with the same information form the original mini tables.

A pivot table in that stage won't be a good idea, because, from the master spreadsheet I'll make some pivot table to generate different reports, and a SUMIFS to make a yearly cash-flow statement, that works pretty we'll making all the inputs to update atomically.

Any type of help or suggestion would be highly appreciated, as I have been spending long hours trying to figure out it.
Formulas would be well come, however VBA could be a solution if user does not need to press any bottom :0


I am using a excel 2011 for mac.
Spreadsheet sample attached.