Macro to auto log data between sheets

Hi Guys,

Ok I been trying to get my head around a macro to log records on the attached spreadsheet:

Here is what I need:

The main page logs performance week by week but only shows the last 3 weeks worth. There is a corresponding tab for each of the fields which logs them on a more long term basis.

Right now each time i enter a new week's worth of info I have to copy all information under "3 weeks ago" headings and paste them into the relavant sheet, then i need to move the other 2 weeks of info along one, so "week before" then becomes "3 weeks ago" and "last week" becomes "week before" so I have a new space under "last week" to fill out the new data.

Here is what I want my macto to do:

When macro run:

copy all data under "3 weeks ago" (wrap, Sales, Payments etc etc"

paste them in the next available blank space in the corresponding sheet (Wraqp log, Sales log etc...)

move the remaining 2 weeks worth of data along so there is a fresh space under "last week"

PLUS

there is also a list of the best /worst performers.

This only displays the names for the previous week ... so...

I need the macro to pull the names and scores for mest and worst performance, and save them in the logs (wrap log, sales log etc) but these are for the last week so will need to be put in the correct place (normally 2 columns over from the data that has been pulled for the "3 weeks ago section"

Hope this makes sense, any questions please ask

Thank you in anticipation

Spreadsheet attached