Help on VBA Code to split rows into newwb depends upon cell criterial

Dear Experts

I need an vba code to help my data split as new workbook sheet

in the excel file Master data have sheet rawdata G:G column contains module data
i want move data which is contains key string Disconnect,Cancel,Cancellation,Suspend,(Lanx - Active)

for e.g Disconnect - Fibre to the Basement(WMS)
Cancel - Fibre to the Basement (KML)(KML)
GT-Flight Cancel Fibre to the Distribution Point/Curb(WMS)
GT-Flight Cancellation Fibre to the Distribution Point/Curb(WMS)
Suspended - Fibre to the Node(WMS)
- Hybrid Fibre Coaxial(WMS) (LanX - Active)

like kind of key matching strokes in text values might be in prefix or suffix or in between text values in every row
all Disconnect data move to disconnect sheet
all Cancel,suspend,(LanX - Active) move to cancel sheet.

please find the attachment bin file is my expected result

try

Please Login or Register  to view this content.

Brah i want save data without asking open particular folder ,
Can u do small favor make it to save data to located target file on particular sheet becoz i going to loop this code with more actions call
i saved Bin_file in this is file path C:\Users\Windows 10\Desktop\BT_Project

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks alot brah works 100%

Hi Experts , I opened thread on code i just re-form the code instead of G i assisgn AO as filter column but it does not work,
i want copy entire range from A:BI filter column is AO, once copied and moved to target files sheets. copied data should be deleted in masterfile.

Please Login or Register  to view this content.

pls help on this.