populate sheet 2 using sheet 1 with a drop down

This is the same as my previous post, except the previous one had a very vague title and I didnt know how to change it...sorry!

Hi, I am having a meltdown. I have been working on a workbook and I have three questions...one mainly, two little ones.

Question 1

I have three sheets (weekly attendance, weekly eval, progress report) The attendance sheet all data is entered manually in the form of A or E and that populates a portion of the weekly eval with a percent either 0 or 100. In the weekly eval there are four sections (each representing one week, week 1,2,3,4) and within each week it is broken into 4 more sections (each represented with a different letter ex. A = Attendance, the letters are T,U,A,P) the A if populated automatically from the first sheet but the other three are put in manually each week. The sheet is also divided into 60 people. One person on each row, so it breaks down to a person having four weeks of evaluations four sections for each week and four weeks (all one row, one row per person) this makes 16 cells with data that I want to transfer to the third sheet (the progress report) I originally started with 60 progress report sheets then decided it would be easier to make one sheet with a drop down list of all the names from the weekly eval sheet. The only problem is I dont know how to make it so that when I select a name from the drop down list it takes the information from that specific persons rown and puts it into this sheet. the format for the progress report is a little different, where the weekly eval is all one row per person the progress report is more of a table where there are four columns (week 1, week 2, week 3, week 4) and four rows (one for each letter, T,U,A,P) so still the 16 cells.

Question 2 (much simpler)

I will be printing off the progress reports and the weekly eval sheet once every four weeks so I can keep a hard copy on file. Is there a way to put a button on the weekly eval sheet to clear all the data I put in at the end of the four weeks

Question 3 (also simpler)

I have the names sorted by rank (warrant officer, sgt, cpl) and when I sort them either ascending or descending I want the data to stay with the person, instead of the names moving and the data staying in the same spot.

This is very important and needs to be finished ASAP, so any help would be GREATLY appreciated. Thank you in advance!

1) take a look at the vlookupfunction
2) a basic macro should be able to do this for you
3) make sure you select all of the data before you click on sort and not just the name/rank column.

thanks, I figured out the macro, and the sort thing...but Im still not sure about populating from the dropdown...how would I set that up?