Pivot table from multiple sheets

M

Mark Hauschild

I have data in multiple sheets. I am trying to create a 3D pivot chart. I
have the chart in 3D form with data from one column of the sheet and I need
to grab this same column (Column H) from multiple sheets and graph the data
in a Count of column, data, sheet name. If it sounds confusing, it's really
not.

X=Sheet name
Y=Count of Version
Z=Version

Any ideas???
 
Top