Lookup and paste as value
 

I'm creating a time off worksheet. Every two weeks the date changes. I'd
like to link the recorded time off to a summary sheet that won't change. I
'm trying to create a macro that will copy the total time off for that pay
period, look up the corresponding pay period on the summary worksheet, paste
it into that row as value so that the data isn't lost the following week. Is
this doable?? Is their an easier way to accomplish the same end?? Thanks for
your help.