Debra Dalgleish shows how he
http://contextures.com/xlPivot08.html

Me?

I've always copy|pasted to a new worksheet that held all the data.

mike_vr wrote:

Hi there

Just a quick one pivot tables. Say I have multiple worksheets all with
35k lines or so, all with the same headings and data formats, is it possible
to create a pivot table that looks at all four tabs and sums them into one
table on one worksheet?

Thanks

Mike

--

Dave Peterson