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

thx