You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"yhoy" wrote in message
...
Thanks! That works like magic!!!

"T. Valko" wrote:

If there are spaces or numbers in the sheet name then you have to use
single
quotes around the sheet name:

A1 = sheet name = Week 2
B1 = a cell reference = A1

=INDIRECT("'"&A1&"'!"&B1)

Which evaluates to: ='Week 2'!A1

--
Biff
Microsoft Excel MVP


"E.Q." wrote in message
...


Could it be that you need the exclamation point? If cell A1 has sheet
name
and A2 has cell location try
= Indirect(A1&"!"&A2)