Hi Dan

It doesn't really need a vb solution for this one. In Sheet 3 if you
make a reference to your dropdown so cell A1 of Sheet 3 has the same
month selected ie Jan, you can then use a HLookup to gather the data
based on the month selected in A1 of sheet3.

Then place this code in A2 of Sheet3.

=HLOOKUP(A1,Sheet2!$A$1:$L$10,3,0)

It will pick up the value in the third row of Sheet3. Change the
number 3 in the lookup formula to get other figures ie 5 will pick up
the data in the 5th row. The Sheet2!$A$1:$L$10 may need to be
increased for your purposes.

Take care

Marcus