Macro or Pivot problem?

[mzspazchick]

I have a problem. When I click on a macro button I created yesterday, my pivot tables refresh with the new data I have entered. Only, my pivot tables appear to be scrambling the data. I have one pivot that calculates a total dollar amount and its $1,400,000 over what it should be for one person.
Could row headings affect this? I have to rows with similar names. For example, one is Invoice Amount and the other is Invoice X Markup.
I have 12 columns of data going into seven pivot tables. All pivot tables are similar in that they have the name of a person and the sum, average or count of something else.
Michelle

 

[mzspazchick]

So far, so good. Thank you ChrisM for all your help and patience. It is greatly appreciated. Will report back if I run into any more problems during testing.
Michelle