Need help with excel Project tracker Macro

I also attached the Spreadsheet and the below description in Word format because there is definately confusion now with the formatting.

Here is the link to my spreadsheet. Some data has been inputted for testing.

http://www.speedyshare.com/files/229...macro_help.xls

I am creating a project tracker workbook. I need help with a macro that will:

1. Unprotect sheets, “Overview,” “Walter,” “J.D.” “Patrick,” “Howard,” “Dave”.
a. Note there is no password to input, just unprotect.
2. Sort column F of sheets, “Walter,” “J.D.” “Patrick,” “Howard,” “Dave,” to “100%.”
3. Copy the sorted items (A5:G70) and paste into sheet “Archive.”
a. In the “Archive” tab, the data should be a continious list (not overwrite the previous data).
b. All rows in “Archive” tab should conain “100%” in column F.
4. Go back to sheets, “Walter,” “J.D.” “Patrick,” “Howard,” “Dave,” and delete the sorted “100%” data.
a. Do not delete the Formula in column A, or the formatting.
5. In sheets, “Walter,” “J.D.” “Patrick,” “Howard,” “Dave,” undue all the filters (set to “All”).
6. In sheets, “Walter,” “J.D.” “Patrick,” “Howard,” “Dave,” copy the remaining data (A5:G70) and paste into the next available cell in the “Overview” sheet.
a. In the “Overview” tab, the data brought in should OVERWRITE the previous data.
b. No rows in “Overview” tab should contain “100%” in column F
c. There should be no blank rows in between the data.
7. Protect sheets, “Overview,” “Walter,” “J.D.” “Patrick,” “Howard,” “Dave”.
a. Allow “Auto Filter”
b. Allow to select unlocked cells
c. Allow Edit Objects.
8. Go to “Overview” sheet.
9. Save

After running the “Update” Macro, the following should be accomplished:
• No rows in “Overview” tab should contain “100%” in column F
• All rows in “Archive” tab should conain “100%” in column F
• No rows in tabs, “Walter, “J.D.,” “Patrick,” Howard,” Dave,” should contain “100%” in column F
• No formulas in column A, in tabs: “Walter, “J.D.,” “Patrick,” Howard,” Dave,” should be deleted.
• In all the tabs, there should be no blank rows in between the data.
• In the “Overview” tab, the data brought in should OVERWRITE the previous data.
• In the “Archive” tab, the data should be a continious list (not overwrite the previous data).
The macro “Update” that is in the Excel sheet, I believe to be in the order in which the procedures have to execute. However, if this is used as a guide please not that it doesen’t fully function the way it needs to. The errors I see are:
1. “Overview” worksheet
• Blank Rows in-between data.
o Starts with 2 blank rows
• Currently data is entered. Walter, J.D., Walter, J.D. Patrick, Howard, Dave, Walter, J.D., Patrick, Howard, Dave, Walter, J.D., Patrick, Howard, Dave, Walter, J.D., Patrick, Howard, Dave, Walter, Walter, J.D., Patrick, Howard, Dave. It should be entered, Walter, J.D., Patrick, Howard, Dave.
• There is 100% values in column F.
2. Sheets, “Walter, “J.D.,” “Patrick,” Howard,” Dave,”
 have 100% data in column F.
3. “Archive: sheet
 Should only say 100% in column F.
 Data coppied twice.
 Blank rows in between Data.
 Sheet not protected.

Please Help!!!
Thanks!