Excel: Copying conditional data to new sheet

Hello,

I have been given a half-done spreadsheet to make into something useable, hopefully someone will be able to help out.

I have a workbook with two sheets - 'Data' and 'Merge Data'

The information in 'Data' is manually input but does have some dynamic data (changing dates to week numbers - but this all works fine). What I need is a something which will copy the complete row from 'Data' to 'Merge Data' if any of the cells from 'Data' L:N are equal to cell B1 in 'Data'.

In Visual Basic there is the following:

Sub test()
Set a = Sheets("Data")
Set b = Sheets("Merge Data")
Dim x
Dim z

x = 1
z = 2

Do Until z = 9999

If a.Range("L:N" & z) = "a.Cell(B1)" Then
x = x + 1
'b.Rows(x).Value = a.Rows(z).Value
a.Select
Rows(z).Copy

b.Select
Rows(x).Paste.Paste Special

End Sub

It doesn't work.

Help?!

Thanks