Maybe:

Sub Nisar_mohammed()
Range("B1:B" & Range("B" & Rows.Count).End(3).Row).AutoFilter 1, "=*1.5*", xlAnd, "=*200603*"
Range("B2:B" & Range("B" & Rows.Count).End(3).Row).SpecialCells(12).EntireRow.Copy Sheets("SKU 1.5").Range("A" & Rows.Count).End(3)(2)
ActiveSheet.AutoFilterMode = False
Range("B1:B" & Range("B" & Rows.Count).End(3).Row).AutoFilter 1, "=*0.6*", xlAnd, "=*200602*"
Range("B2:B" & Range("B" & Rows.Count).End(3).Row).SpecialCells(12).EntireRow.Copy Sheets("SKU 0.6L").Range("A" & Rows.Count).End(3)(2)
ActiveSheet.AutoFilterMode = False
Range("B1:B" & Range("B" & Rows.Count).End(3).Row).AutoFilter 1, "=*0.33*", xlAnd, "=*200601*"
Range("B2:B" & Range("B" & Rows.Count).End(3).Row).SpecialCells(12).EntireRow.Copy Sheets("SKU 0.33L").Range("A" & Rows.Count).End(3)(2)
ActiveSheet.AutoFilterMode = False
End Sub