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.

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.

Thank you, Mr. Mike Fogleman. Works splendid.