Consolidated data from 3 worksheets and populate to another sheets

Hi All,

I have one workbook contains multiple worksheets.
Sheets database as database all transaction, sheets S7 as database limit and sheet S6 as counterparty name.

I already have macro code, but it's run slow. Any one could help me with this case.


Edit Post:

I need to store data in array an populate to sheet.
Example:
Sheet "database":
Ctg | utilisasi | BNB |
A | 20 | Y |
B | 10 | N |
A | 5 | Y |
A | 25 | Y |
B | 2 | N |
C | 100 | Y |
D | 22 | N |
D | 10 | N |

Sheet "name":
LBL | Full |
A | Andaro |
B | Bandada |
C | Calamanta |
D | Delemi |

Sheet "Limit":
Code | Limit | BNB1 |
A | 200 | Y
B | 300 | N
C | 100 | Y
D | 50 | N

Result that i need:

Sheet "1":
CTG | CTG NAME | LIMIT | UTILISASI | AVAILABLE LIMIT
A | Andaro | 200 | 50 | 150
C | Calamanta | 100 | 100 | 0

Sheet "2":
CTG | CTG NAME | LIMIT | UTILISASI | AVAILABLE LIMIT
B | Bandada | 300 | 12 | 288
D | Delemi | 50 | 32 | 18

Thank you,