Transferring Data from many sheets to a single sheet

Hey!
I'm loving these new formulas that i'm learning here and applying them to whatever sheets i come across to make my life easier at work...

So now i've created another worksheet, this one is to help my colleague who wastes atleast an hour everyday to generate a consolidated report of our bank accounts...

Now i've sorted out half of the report where he can give an overview of the position of cash flow on a daily basis.

Theres however 1 more addition i wanted to make to make this workbook absolutely perfect!

On sheet 2 (which is my consolidated report sheet) I want to add all the transactions that occur on a particular date from all the different bank accounts (Each account having a seperate worksheet)

I'm not sure if advanced filters can achieve this or not or even easier/short macros... Any tips/hints as to how i can achieve this would be awsome..

I've attached a sample workbook which has sheet1 for a bank account and sheet2 for report generation...

I want to add all the rows having "Clearing date" (column A) in Sheet1 to report date in Sheet2
..And this for all the account sheets i can add...

Thanks For all the help!

Regards

Mohit