Keep Values and Formulas
 

I have a sheet which has formulas to vlookup and copy information from
another sheet based on a weekly date.
I can get the new information into my column, arranged by date.
What I would like to do, is to re-load the second sheet with new data, and
vlookup/ copy the new data into the next column, which has the next week's
date.
I know I can go into the first column and copy / paste special / values to
keep those results, but I was hoping to do this without user interaction.

So the question is:
Can I add something to the vlookup that will paste values without losing all
the remaining formulas?

TIA