Use search box to extract the relative data from a different worksheet etc

[helpmyexcel]

Hi all,

Looking to create a search box with option buttons that once pressed searches a different worksheet for the search box content, then with all rows where this is present, copy them onto a neighboring worksheet and remove a few of the irrelevant columns at the same time.

Complete beginner to VBA, so also any help connecting this to the search button/text box would be great

Many thanks