This post is particularly timely. I am today struggling with a similar
dynamic referencing issue.

I need to reference a table on another sheet. I actually want to
mirror pivot tables that are on each monthly sheet.
Currently I try to reference them as =jan!F204 thru =jan!L221
Unfortunately the row references might also change as rows are
added/deleted. As the sheet reference changes over time it would be
good if it continued to flow with the changes.
I have tried a suggestion in the lit. to present a pivot table of the
pivot table. Far too complicated!

Help...


--
Ken B
------------------------------------------------------------------------
Ken B's Profile: http://www.excelforum.com/member.php...o&userid=31274
View this thread: http://www.excelforum.com/showthread...hreadid=509375