Hi.

Here is my situation, I have 3 worksheets of data. All these worksheets contain different information except for the items I want to use as rows. (which there are three). I need to create one pivot table with all of these sheets, however I don't want a consolidated sheet, because I need to maintain flexibility in manipulating my rows and columns. I'm no good with VBA, plus I need to create something that other (non-excel types) can work with.

Can anyone point me in the right direction?

Audra