Try this...

=INDIRECT(TEXT(ROWS(A$1:A1)*29,"mmm")&"!G2")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Malla" wrote in message
...
Kindly i need help on below:

i have a formula as "=Jan!G$2" in Cell "A1", i'm looking to have
"=Feb!G$2"
in Cell "A2" and "=Mar!G$2" in Cell "A3" and so on by simple dragging.
is that possible?