Insert Column then insert designated number

Attached is a test book that displays the basic format of the spreadsheet I am working on.

Again the steps I am trying to complete are:

-Delete first 6 rows in the spreadsheet
-Delete all of the rows following the last name entry
-Insert a column between column A and B to become the new second column
-Title the column "Week"
-Allow the user to identify the week number
-Copy that number down the column

Hopefully this clarifies things a bit more. Thanks again for your help!