Thanks Pascal,

Your solution worked first time. I think I tried that option, but must have
had the syntax wrong.

Anyway, thanks again.

Thanks also to Arvi for his comments. A little too complex for a simple
soul such as me, but interesting nevertheless.

Thanks guys............

"lutts" wrote:

In Excel 2002, I am referencing data from an external worksheet via the
following formula:

='[BSG AGED DEBTOR ANALYSIS 2005.xls]Jul-04'!D11

I would like to make the "Jul-04" part variable based on data entered to the
current worksheet. If I specify, say "Aug-04", I would like to extract data
from the "Aug-04" tab of the external worksheet, and so on..........