I have Worsheets(1) is where the searching occurs. Column E of Worksheets(2 to n) will be searched.
In worksheet(1) I have a textbox the receives the string to be searched.

Code:
countWS = ThisWorkbook.Sheets.Count
resultRow = 5
For cursor = 2 To countWS
   'seach and paste each result on Worksheets(1).Cells(resultRow, 2)
   'resultRow = resultRow +1
Next cursor