Pivot Tables with Multiple ranges
 

I am trying to create pivot table with multiple ranges because ther is too
much data for 1 spreadshhet and I don't want to consolidate. I am selecting
datas from 3 different tabs and all are in the same formate with 7 columns
but have differenet numbers of rows.

when I select the ranges and create the pivot table the only options I have
to put into the Page header and body are Row, column and Value. This isn't
flexible enough I wanted to be able to slect from all the fields in the data
ranges.

Is there a solution? Have I done something wrong?

Thanks
Rick