I have two spreadsheets. In one there is a column containing employee's names and a separate column containing the hours worked each day in the month. The second spread contains space for the employees names and for hours worked each day of the month. The second spreadsheet facilitates the use of the hours worked data from the first spreadsheet. Without creating a link. I must each month copy the row for a given employee from spreadsheet one to spreadsheet two. I want to automate this process (e.g. a macro) is it possible.

Optional Information:
OS: Windows XP

Already Tried:
I have tried recording the operation into a macro, but the cell range of origin and the destination cell range would need to change each time the macro is executed. This did not happen when the macro was executed.