If you copy data to the summary page, the copy will have to be repeated every
time the source change. Why not just use a link?:

=Sheet3!G10

--
Gary''s Student
gsnu200708


"billinr" wrote:

I have a workbook with several sheets; I am trying to create a dynamic
summary page - one where the cell values are live links to the cells on the
other sheets.
The sheets I am copying have variable used ranges.
I can copy the used range (Thanks Ron DeBruin), but I am unable to have the
result show as "=sheetname!celladdress".

Any help is appreciated.

Thanks