Maybe:
Sub aovermille()
Dim lr As Long
Dim rcell As Range
lr = Cells(Rows.Count, 10).End(xlUp).Row
For Each rcell In Range("J2:J" & lr)
Select Case rcell.Value
Case Is = ""
rcell.EntireRow.Copy Sheets("Received").Range("A" & Rows.Count).End(3)(2)
rcell.EntireRow.Delete shift:=xlUp
Case Is = "Pending"
rcell.EntireRow.Copy Sheets("Pending").Range("A" & Rows.Count).End(3)(2)
rcell.EntireRow.Delete shift:=xlUp
Case Is = "Rejected"
rcell.EntireRow.Copy Sheets("Rejected").Range("A" & Rows.Count).End(3)(2)
rcell.EntireRow.Delete shift:=xlUp
Case Is = "Authorized"
rcell.EntireRow.Copy Sheets("Authorized").Range("A" & Rows.Count).End(3)(2)
rcell.EntireRow.Delete shift:=xlUp
Case Is = "Returned"
rcell.EntireRow.Copy Sheets("Returned").Range("A" & Rows.Count).End(3)(2)
rcell.EntireRow.Delete shift:=xlUp
Case Is = "Issues"
rcell.EntireRow.Copy Sheets("Issues").Range("A" & Rows.Count).End(3)(2)
rcell.EntireRow.Delete shift:=xlUp
End Select
Next rcell
End Sub
Untested try on a copy first.
Bookmarks