excel macro variable

[theresap]

I am using excel 2007
The macro goes to each sheet to a specific range and pastes the values instead of the formula before saving the file. Next week we use the same macro and change the range to the next cells, paste the values and then saves.
Currently I am manually changing the macro to the next range. So below Range("J16:K16").Select, will be changed to Range("J17:K17").Select and the next week changed to Range("J18:K18").Select

'save sheet2 weekly data
    Sheets("sheet2").Select
    Range("J16:K16").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False

The data (J16:K16) is always found in Sheet1!M2. as my reminder of what to change it to.

What I am hoping is that you know how to change the line Range("J16:K16").Select so it will automatically put in the data from Sheet1!M2 so I do not have to manually adjust the macro before running it each week.

Thanks for answering my question.