I have a project in which I am assigning you a task , so basically You are hired as developer & your task is to write VBA CODE. We have sheet 1 that is consolidated  in that sheet column M has comments. We will be sorting data in 3 section - 1. Remove " NAME_1", ",No Bc" ,"Dup"&"Duplicate"
2.only select " NAME_1" & " NO BC "
3. ONLY DUP & Duplicate
Each section will be pasted in the Individual sheets of  different workbook.