create a new worksheet based on existing worksheet that only displays the last X cols

I have a worksheet that does calculations based on the last 2 weeks of data, so basically I enter data like this:

SHEET1

Please Login or Register  to view this content.

Every week I have to replace the Week1 and Week2 columns, but basically I just move Week1 to Week2 and I add in the new week's data.

I'd much rather be able to just create a "rolling" master list of every week in a new SHEET2 and have SHEET1 automatically populate itself by pulling the last (or first depending on your pov) two weeks of data. The data will always only be only two columns (so I don't have to worry about that), but the length (number of rows) may vary.

SHEET2<-- new sheet next week with added week of data (no headers)

Please Login or Register  to view this content.

SHEET2<- SAME sheet next week with added week of data (no headers)

Please Login or Register  to view this content.

etc.

hi, anyone?

Keepon adding data (SKU and qty) in sheet1
in sheet2 will get the latest two weeks data