Multiple table pivot

[J4cob]

Hi,

I have a file with a bunch of cash books on each sheet, each categorised exactly the same (i.e column S will be the same category on each sheet).

I can create a pivot table based on one sheet, but can I do the same adding all the sheets together.

https://ufile.io/r7ypb - this is a simple version of what I want to do. I want the Pivot tabel on the first sheet to add the same results in all the sheets.

Thanks,

J

 

[arthurbr]

Do you mean like this http://contextures.com/xlPivot08.html ?

 

[J4cob]

Ye, something like that.

Thanks!