I'd like to copy multiple rows based on the criteria entered into a text box,
using wildcard search capability and then be pasted onto another sheet.

Eg, copy all rows where "test*" is in column A.