Drop down list question
 

I'm trying to modify a spreadsheet with a number of automatic functions and I
am sadly lacking proficiency with excel.

1. I want to create five columns (B-F) with different drop down lists of text

2. I would like each text in the drop down lists to equal a number value,
i.e. 1-7

3. I then want the "A" column to find the sum of columns "B-F"

4. Finally, I would like the rows to automatically sort based on the value
in column A

I'm not sure how well I explained that, but I would greatly appreciate it if
anyone could lend me a hand.