Code to copy selected data based on critera in a table

Hi,

So I have the following:

Data in columns A:CL

In Column A, the majority of data containes the data "DWPK".

I need to copy any row that contains DWPK in column A and paste onto workbooks("Report 27 with Macros") on tab "Test".

Thanks!