Hello,
I have a workbook which has worksheets for each day of the month (i.e. "1",
"2").
I would like to retreive the figure in cell C164 of each worksheets (i.e.
for each day of the month) on to another workbook. The other workbook where i
want the figure to show, i have the dates running horizontally at the top and
i want the figure in cell C164 of the other worksheet to show up in the
corresponding date in this workbook.

thanks,