Need vba to copy data from rawdata depends upon list of debt into debt sheet

Dear experts

I have accounting database in tab "DATA" and another tab Report contains some of source&Co_code of rawdata.

i want copy data from B to E under individual ledger depends upon report value contains in range A2:B20.

and paste into sheet(Debt) one by one with separate format.

one combination is compulsory if come either 291202 or 570507 should include both.

please find the attachment you may understand.

any experts help on this?