Sub Test()
Dim Sh As Worksheet, Rng As Range
Set Sh = Sheet1: Sheet1.Select
Set Rng = Sh.Range("A2:D" & Cells(Rows.Count, 1).End(xlUp).Row)
With Rng
.AutoFilter Field:=1, Criteria1:=RGB(255, 0, 0), Operator:=xlFilterCellColor
.SpecialCells(xlCellTypeVisible).EntireRow.Copy Sheet2.Range("A1")
.AutoFilter Field:=1, Criteria1:=RGB(255, 255, 0), Operator:=xlFilterCellColor
.SpecialCells(xlCellTypeVisible).EntireRow.Copy Sheet3.Range("A1")
.AutoFilter Field:=1, Criteria1:=RGB(0, 176, 80), Operator:=xlFilterCellColor
.SpecialCells(xlCellTypeVisible).EntireRow.Copy Sheet4.Range("A1")
.AutoFilter
End With
End Sub