Excel Spreadsheet Modification and Set-up

We want to update the attached excel spreadsheet with dependent drop down menus and update the pivot table to include the changes. Pretty simplistic task for someone familiar with excel. The "Categories" sheet contains the basic category list (yellow) that is referenced in Column D-Category on the "Expense Entry" sheet. It also contains the Sub-Category ("Motor vehicle expenses"-orange, "Capital cost allowance"-green, "Business-use-of-home"-dark blue & "Other expenses"-blue) & Rate info associated with the relevant green selection. The "Class 29"-green selection would have 3 associated options that would auto populate after selecting. The other classes have static rates associated. We want the new data in the "Expense Entry" sheet to have Column E-Sub Category to be dependent on the item selected from Column D and the data in Column F-Rate would be auto populate based on the the data selected in Column E, with the exception of Class 29 (drop down then auto populate based on selection.) The green Classes would also have a pop up associated with each item found in Column F, Rows 42 to 56. This would be used to assist in selecting the appropriate Class on the "Expense Entry" sheet. The last item would be to check and confirm that the pivot table in the "Quarter Summary" is functioning with the new features. Any questions please let me know, Thanks from Aenco.