It is not entirely clear what you require. If you just wish to have the
month that the date is in returned eg if today is 1-apr-06 you want the
summary data from the sheet apr returned, but if it was 1-may-06 you
would want the data for may returned try

=INDIRECT(TEXT(MONTH(TODAY()),"mmm")&"!"&CELL("add ress",D14))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=534444