Row of references to same cell in several worksheets
 

Hi.

I have a workbook with one summary sheet and dozens (if not more) of
worksheets all named x.y, where x=number of day and y=number of month.

I need to make a table in the summary sheet where the first row shows the
date (e.g. x.y or 14.6) and the second row shows a value (say, $A$1) from its
respective worksheet.

How can a make a cell from the second row refer to a sheet using the value
from the first row in the second row's reference formula? In other words, how
can I make a cell reference to a cell in another sheet without having to
manually refer to that particular sheet?

Thanks.


PS. I have tried to use the concatenate function within the reference
functinon, but to no avail.

Row of references to same cell in several worksheets
 

Johab: In cell A2 put this formula

=INDIRECT(CONCATENATE("'",A1,"'!","$A$1"))

Mike F
"Johab" wrote in message
...
Hi.

I have a workbook with one summary sheet and dozens (if not more) of
worksheets all named x.y, where x=number of day and y=number of month.

I need to make a table in the summary sheet where the first row shows the
date (e.g. x.y or 14.6) and the second row shows a value (say, $A$1) from
its
respective worksheet.

How can a make a cell from the second row refer to a sheet using the value
from the first row in the second row's reference formula? In other words,
how
can I make a cell reference to a cell in another sheet without having to
manually refer to that particular sheet?

Thanks.


PS. I have tried to use the concatenate function within the reference
functinon, but to no avail.

Row of references to same cell in several worksheets
 

Thank you, Mr. Mike Fogleman. Works splendid.