Question: how to transfer data from one sheet to another in excel based on criteria?
Answer: Select the range that you will copy rows based on column criteria, and click the Enterprise > Split Data.
In the opening Split Data into Multiple Worksheets dialog box, you need to: ... 
Click the Ok button.