Summarised?

=SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1" )))

or just referenced

=INDIRECT(COLUMN()&"!A1")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" wrote in message
...
Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31
of
them are the same and will be as days of the month, the last sheet is used
to
track commisions. I would like to be able to automate the process to move
the sold information from 5 different cells, meaning if there is anything
in
those cells move the name information to the commision page. Please help!