There are no macros visible in the attached file, presumably stored elsewhere.
You need to loop your "Search Codes" through all sheets in turn, adding results from successive sheets below your current results
something like:
For j = 1 To to Sheets.Count
'INSERT your "SearchCode" HERE , ensuring search ranges refer to sheet(j)
Sheets(j).Range("A:F") 'example
Next j
OR
For j = 1 To to Sheets.Count
'wrap code in With statement and use .range notation
With sheets(j)
'INSERT your "SearchCode" HERE, ensuring search ranges refer to sheet(j)
.Range("A:F") 'example
End With
Next j