You could use a dynamic range as the pivot source, and refer to the
range name in the code. There are instructions he

http://www.contextures.com/xlPivot01.html

Joyce wrote:
Can I set up one datarange (i.e. all the data in worksheet 1) that all my
pivot tables call to?

thx


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html