Perhaps the following code may help:-
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In Worksheets
If ws.Name <> "Master" Then
With ws.Range("H5", ws.Range("H" & ws.Rows.Count).End(xlUp))
.AutoFilter 1, "No"
On Error Resume Next
Sheet1.Range("A" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues
ws.AutoFilterMode = False
Application.CutCopyMode = False
Application.ScreenUpdating = True
It will filter Column H of each sheet for the criteria "No" and then transfer the relevant row of data to the Master sheet. It will work on any number of sheets that you may have.
I have prepared a small sample for you to play with at the following link:-
Click on the "RUN" button to see it work.
I hope that this helps.