One way

=INDIRECT("'"&A10&"'!"&CELL("address",A2))

this will also work

=INDIRECT("'"&A10&"'!A"&ROW(2:2))

however it's less flexible than the former

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Genesis" wrote in message
oups.com...

Roger Govier wrote:
Hi

If A1 contains august, and you want the data from cell A2 on the sheet
august, then
=INDIRECT(A10&"!A2")

--
Regards

Roger Govier



Thank you all..

Roger or anyone , i used the the INDIRECT formula you gave and it
worked..but I can't seem to drag down. It keeps anchoring to A2 only..
i want it to be able to it down A3,A4,A5, ETC .. how can this be done
using this formula??

Thanks again.





"Genesis" wrote in message
oups.com...
Hello all,

I a workbook with 13 tabs, of which 12 of them are names of the month
(jan -dec). The 13th tab is the summary page. On the summary page, if
cell A1 changed from say "june" to "august", I need to know if it's
possible for excel to pull the data from the "august" tab. In other
word, whatever month appears in cell A1 of the summary tab, I want
cell
A2 to reflect the value from the coresponding month's tab. Please help
if you can as I need this urgently. Many thanks.