Insert Column then insert designated number

I am currently attempting to create a macro that does the following:

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

While I can record simple macors, the needs of this particular macro are a bit beyond my understanding. Any help with this is greatly appreciated.