That is a great tip, and I have a question that is similar.

Say that I have several worksheets with the same data layout.

I also have a sheet up front that is a summary sheet of all the other
data sheets.

I would like to list out the data of a specific cell (D50) for each
sheet on the summary sheet.

Is there an easy way to do this?

Edit: I should say that currently I am hand linking each value to the
summary page... this is very time consuming and I am looking for a
shortcut.


--
gwexcel
------------------------------------------------------------------------
gwexcel's Profile: http://www.excelforum.com/member.php...fo&userid=6845
View this thread: http://www.excelforum.com/showthread...hreadid=396645