Copy entire row to new spreadsheet based on keyword

Hi guys, just wondering if anybody could help me with this one.

I have multiple Sheets Jan12,Feb12,Mar12 etc and what I would like is to search for a specific keyword in column K and if that keyword matches then it will copy the entire row containing that keyword into a new spreadsheet. So basically if there are 3 rows in Jan12, 6 rows in Feb12 and 10 rows in Mar12 containing the keyword then the resulting spreadsheet will show 19 rows containing the data copied from the other sheets.

I have seen some examples but only ones which will work for the activesheet, I am trying to get a macro that will search in a specified number of sheets. Thanks

Hi Patel,

No sorry that didnt seem to do anything, do you need more specific information from me? The keyword I will be using will be "Carmens". Thanks for helping btw

Hi guys, I did change the keyword from xxx to Carmens but that didnt seem to do anything either.

Only just realised it would be a better idea for me to upload exactly what I am after. This is the spreadsheet, but in this one It would be looking for the keyword in column F and not column K, and if possible for it to look through all the sheets within the workbook. Would greatly appreciate any help

here is the spreadsheet

Hi Mike,

Thanks for your help it works perfectly now!

could I also just ask, is it also possible to search for more than just 1 keyword? for example if i wanted it to show results for CARMEN and JOHN would it be a case of changing the sname = CARMEN & JOHN or would I need to create an additional sname e.g.

sname = CARMEN
sname1 = JOHN

and also have to change this part to:

If UCase(.Cells(j, "F").Value) = sname & sname1 Then

thanks alot for your help guys, saved me alot of time