=INDIRECT("'"&TEXT(MONTH(A1)*30,"mmm")&" Draws'!G4")

Or, more simply:

=INDIRECT("'"&TEXT(A1,"mmm")&" Draws'!G4")

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Another way. Much shorter but uses a volatile function.

You'd have to standardize your sheet names, though. Some use the short
month name: Jan, Feb, Mar. And some use the long month name: April, June,
July. You'd have to make them all the same, either short or long. Then:

For the short month name:

=INDIRECT("'"&TEXT(MONTH(A1)*30,"mmm")&" Draws'!G4")

For the long month name:

=INDIRECT("'"&TEXT(MONTH(A1)*30,"mmmm")&" Draws'!G4")

--
Biff
Microsoft Excel MVP


"Rookie" wrote in message
...
I know that I am exceeding my nesting levels. But can anyone provide a
fomula
that would help me make all 12 months work? Here is the first 6 months
formula that I have:

=IF(MONTH(B4)=1,'Jan Draws'!G4,IF(MONTH(B4)=2,'Feb
Draws'!G4,IF(MONTH(B4)=3,'Mar Draws'!G4,IF(MONTH(B4)=4,'April
Draws'!G4,IF(MONTH(B4)=5,'May Draws'!G4,IF(MONTH(B4)=6,'June
Draws'!G4,IF(MONTH(B4)=7,'July Draws'!G4,"")))))))