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.