Search text with wildcards in a table and return result as list in other sheet

Hello,

I hope there is somebody who can help me, i'm a little confused

What i'm trying to do:

On sheet2, i have a table with 4 columns and x rows
On sheet1, i have a cell with a text value like "Tom*y-Mart*" and a button to start the macro

The macro should search on sheet2 for the value "Tom*y-Mart*" and return all resulting rows to sheet1(from row6 and down). The resulting rows should only show values from column C and D.
When you change the search value and push the button again, the all rows below row 6 should be cleared and new result displayed.

As i'm a macro beginner, i didn't manage to create a working macro yet, but i have attached an example to show what i need to create.

Anyone ideas or suggestions?

Thanks