I have a workbook that has 9 sheets named "Week 1", "Week2"..."Week 9". I
need a macro to do several things in the following order

1. Copy all data on each week to the previous numbered week. i.e. Week 9
data replaces Week 8 data, Week 8 replaces Week 7...Week 1 data is replaced
by Week 2 data. I usually just select the whole sheet and do a copy/paste
values to the previous sheet.

2. A new sheet of data is imported from another file into the Week 9 sheet.
The file is named "Data_9.xls", "Sheet1" should replace the data in Week 9.

3. Every spreadsheet, Week 1:Week 9 needs a column of data added in column
AJ. The header is "Week". I need this column to fill (in every cell on a
line with data) with the sheet name. i.e. on the sheet named "Week 1" cell
AJ1 would be "Week" and AJ2:AJ[END] would be "Week 1"

4. Every spreadsheet, Week 1:Week 9 needs a column of data added in column
AK. The header is "Sector". The formula for each cell is =trim(A2)&"
"&trim(B2) relative to the row it's on. Again this would autofill all cells
as long as there is data.

Can anyone help? Got some help with another spreadsheet here and saved a ton
of time. I love macros! Working on learning to write them myself but in the
mean time this is so helpful!! Thank you so much in advance!!!

Amy