In the target cell, type =, then click the other tab and then cell in that
sheet, and Excel fills it in for you.

--

HTH

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


"Todd Nelson" wrote in message
...
How can I pull a particular cell on each sheet onto a completely separate
worksheet. ex. Sheet1c4, sheet2c4, without having to type each particular
sheet name in?