Nope, didn't quite follow that...
If the formula is : =JUN!A1, where do I insert an INDIRECT to allow the
"JUN" to change to "OCT", for instance?

=INDIRECT(B4!A1) where B4 is the drop down box of months, and A1 is the
reference on the monthly sheet didn't work.