Hi,
in you summary sheet under day 1 enter

=1!c164

in day 2
=2!c164

etc


"Kramer" wrote:

Hello,

I have a workbook with worksheets for each day of the month labeled "1",
"2".."31" etc. In each worksheet i would like to pull the figure in cell C164
of each sheet into another workbook. In the another workbook i have dates
from 1-31st running horizontally at the top. I would like the figure in cell
C164 for each day to show up in the second workbook under it's correct date.

thanks,