Have you tried a =CHOOSE((ref cell),value1,value2,value3,...) formula? I set
up my dashboard so that when my reference cell was the month value it would
refer to the correct column, but you could link to another worksheet or even
workbook like this.

"rachel" wrote:

I want to use the value of the MONTH function within a formula to refer to a
sheet in another workbook eg ='May'! where the reference May comes from the
result of =MONTH(Serial_Number)

Any ideas please

--
Many Thanks
Rachel