Macro lookup

hey all, yeh basically i have two worksheets, one with a row of data (we'll call this data for now) that needs to be special pasted into the other worksheet (week totals). on the week totals worksheet there is a list of weeks, on the data worksheet there is a date. i need the data from the data worksheet to be special pasted (i need only the values) in the row on week totals which the date matches. if that doesn't make sense i'll try and explain it again here is the code ive been experimenting with:

Sheets("Data").Select
Range("C11:F11").Select
Selection.Copy
Sheets("Week Totals").Select
Range("").Select -- this is where i need the row containing the week which matches the week given on the data worksheet
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False