Wildcard search, copy and paste in excel 2010

i am add in a wildcard search in my programming, so far, i am able to search only a single column and i'm able to copy that searched row and paste it in my desired form, what's needed to add into my codes to make a wild card search?

Sub macrotest()
Dim strSearch

 
strSearch = Application.InputBox("Please enter the search string")
x = 2

Do While Cells(x, 1) <> ""


 
If Cells(x, 2) = strSearch Then

Worksheets("Sheet1").Rows(x).Copy

Worksheets("Sheet2").Activate

erow = Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

ActiveSheet.Paste Destination:=Worksheets("Sheet2").Rows(erow)
End If

Worksheets("Sheet1").Activate

x = x + 1
 
Loop
End Sub