Needdrop down menu with two choices as "High Interest Rate Method" and "Snowball Method."

Hi experts,

Could you please help in below scenario.

I need a drop down menu with two choices as "High Interest Rate Method" and "Snowball Method." for D10 and E10 cells f
then

from the cell if user select "High Interest Rate Method" choice the columns values (rows 12-26) automatically sorts the table by Column D (rows 12-26) from highest interest rate to lowest interest rate of entire row .
or
from the cell if user select "Snowball Method." choice the columns values (rows 12-26) automatically sorts the table by Column D (rows 12-26) from lowest interest rate to highest interest rate.

same thing for E10 cell as well.

Thanks,excel scenario.xlsx
Nani