See Mike Alexander's video tutorial on synchronizing pivot tables.
http://www.datapigtechnologies.com/f...s/pivot10.html

Does that help?