Consolidate Sheets With Two Criteria Using VBA?

I have three sheets viz AR , AP, TR where I am capturing the monthly maturities for AP and TR and monthly collections in AR sheet.

All the sheets have same number of columns , the common factor between this three sheets are

1) the status column which contains two status cleared and Not cleared and
2) bank where I have different banks

I need to apply two conditions in the first sheet (named consolidate sheet ) where in the user will select first condition as criteria and the second condition as bank , based on this two criteria all the related information should get consolidated from (AR,AP,TR) sheets to the consolidated sheets

I may add more sheets in the future , it should take that also into account

I was able to apply the first condition that of criteria but need setting up the second condition of Bank .