A macro could do this, but if you want to do it on you lunch break you could
try filtering. On Sheet "CMG SA Master" activate cell A1. Then
<Data<Filter<AutoFilter. Then in the dropdown in cell A1 select "X".
Copy the resulting rows to Sheet "test1".
Clear the selection in column A by selecting all. Repeat with columns B
through F.

I hope this helps in such a hurry.

Tom