Please help me write a macro that will perform the following:

For every worksheets in workbook "book1.xls",

Copy the row where a cell in column k has any value that is not blank

Copy that row and paste it to workbook2's worksheet1.

Thank you in advance for helping!