Move entire row automatically to another worksheet if condition is met

The trick I would use it to have the PENDING REVIEW sheet update itself every time you bring the sheet onscreen. A Worksheet_Activate macro can cycle through all the sheets and collect all the pertinent rows for display.

Put this macro into the PENDING REVIEW sheet tab module:

Option Explicit

Private Sub Worksheet_Activate()
Dim ws As Worksheet, LR As Long

Me.UsedRange.Offset(2).EntireRow.Clear

For Each ws In Worksheets
    If ws.Name <> "MASTER" And ws.Name <> Me.Name And ws.Visible = True Then
    With ws
        .AutoFilterMode = False
        .Rows(1).AutoFilter
        .Rows(1).AutoFilter Field:=5, Criteria1:="<>"
        .Rows(1).AutoFilter Field:=6, Criteria1:="="
        .Range("A2:H111").Copy Range("A" & Rows.Count).End(xlUp).Offset(1)
        .AutoFilterMode = False
    End With
    End If
Next ws

End Sub