Search For Value Specific Value in Cell, Then copy and paste row to diffrent worksheet

[Chrisnicholls1]

Ok, so fairly new to using Macros in Excel. I'm looking to write some code that will allow me to search through multiple worksheets for a specific value in varying columns. I then need to select, copy and paste rows that match with the criteria supplied for said columns and copy this into a different worksheet.

Apologies if this is quiet worded right but I'm hoping someone should get the gist of what I'm on about. I've had a look on several forums to find a solution to this problem but keep hitting brick walls unfortunately. If anyone needs more info to try and solve the issue let me know

Thanks in advance for any help!

[meabrams]

Is the value going to be changing or something that could be hard coded? if its going t b changing how would you need I t change... Based on a cell, a popup Input Box, Userform text box? Might be helpful if you could post a sample workbook so that we might better understand what you need. Make sure to remove any and all personal data.