Ok, I am extremely new to VBA so please forgive me. In Excel I have 4 pivot tables all showing the same field names, but charting different attributes of each. For example, I have 12 different cars. All 12 cars show up on each of the 4 pivot tables, but 1 table is charting the motors (jan - dec), the 2nd is charting the windshield wipers (jan - dec), the 3rd the tires (jan - dec) and the 4th the color of the cars (jan - dec). All I would like to do is when I change the car names on 1, have it update automatically on the other 3 pivot tables so I don't have to make the same change to 4 charts, 4 times. Is this even possible using VBA? And if so, is it difficult? Keep in mind, I have no VBA knowledge. All I have done with VBA was find some code on the internet about how to programmatically clear old items remaining in pivot field dropdowns. I took a chance, pasted the code in for the entire workbook, and it worked, just to give you an example of my VBA knowledge...