I have the below formula which is referencing a Data Valadation list (D5).
Does anyone have any ideas to expand it to inlcude all 12 months?

=IF($D$5="APR07",APR07!F$6,IF($D$5="MAY07",MAY07!F $6,IF($D$5="JUN07",JUN07!F$6,"")))