Search for Text and displaying the results

Maybe try:

Changing this line:

Sub ymaster44()
If Range("E" & CStr(LSearchRow)).Value = SearchTerm Then
End Sub

To one of these?

Sub ymaster44()
'If Range("E" & CStr(LSearchRow)).Value Like "*" & SearchTerm & "*" Then
'Or
'If SearchTerm Like "*" & Range("E" & CStr(LSearchRow)).Value & "*" then
End Sub