Macro to Find data in multiple workbooks and paste it in master sheet

Dear all,

I am trying to maintain a database file named. database.xlsx which i created using data from multiple data sheets, a sample of which is attached named sample.xlsx

My problem is i want to copy data from multiple sheets, based on criteria that
all ACNO (column G) falling under a Single CUSTID (column C), which has either CLOSDT (Column I), or Zero balance(Column AG) available, then that range should be selected and pasted in database.xlsx

I sorted the data according to my needs, but cant figure a way how to use macro/VB to fulfill this task.

Any help is greatly appreciated