How can I refresh my connected data automatically while still retaining the old data.

I have automated several reports but the problem is I have to manually go in and move the updated date each week in order for to keep a historical week by week data spreadsheet.

I am thinking this could happen in one of two ways:

1. either the data I import is placed in a new column adjacent to the current data each time it is refreshed
or
2. Before the spreadsheet is saved, it copies the current data that was just refreshed and pastes it into a "historical" spreadsheet where it is stored over time.

Any ideas or help would be appreciated!