Sheet X has data in A:H. (No headers)
For each row with data, column A will contain either "abc" or "def".

I need to create two sheets
1 - "ABC Group"
2 - "DEF Group"

Filter all rows with abc in A to sheet ABC Group.
Filter all rows with def in A to sheet DEF Group.
Delete the original sheet - SheetX