Create a drop down for each month of th year

Hello,
I'm using Windows and unfortunately, Office 2007.

I want to add a dropdown in the area of cell P17 on the Ranking tab. I want the cell to have an empty cell at the top and the months of Jan, Feb, Mar, Apr, and so on through Dec. These are the column names on the tab Monthly Data.

When the user selects Jan in the dropdown I want the following to happen:

On the Ranking tab, cell M21, I want it to pull from D9 on the Monthly Data tab
On the Ranking tab, cell N21, I want it to pull from T9 on the Monthly Data tab
On the Ranking tab, cell O21, I want it to pull from D26 on the Monthly Data tab
On the Ranking tab, cell P21, I want it to pull from T26 on the Monthly Data tab

and do the same type of pull for each of the cells in Ranking!M21:P30

I've probably overly confused this but any help is appreciated.