Firstly apologies if this is elsewhere on the site, i did look, i am new to excel and dont really know where to start at all.

What i am looking to do is search using a user input and select all the rows that contain the entered search text.

I have 4 sheet workbook, columns are the same accross them all, and what i require is to be able to take a text input from a user, maybe what column to search, and in what sheet. Then search the relevent sheet for matches. Once found the record that contains the match is to be copied to another sheet where filters can e applied. There will be multiple records selected for each search.

I hope this makes sense.

Any advice or pointers to decent tutorials or templates would be much appreciated.