PivotTable from a PivotTable

[AKarim]

Hello to all,
I have a file with multiple informations about costs in 5 different worksheets having different columns.
I'm generating 5 PivotTable from each of those 5 worksheets to format all of them the same way :
A B C D CostYear1 CostYear2 CostYear3

This works fine.
Now I want to generate a single PivotTable (target) from those 5 (source) ones in order to cumulate the yearly costs. The problem is that in the sources PT the data from the first columns are not writen on each line and the target pivot cumulates the info into blanks :

A B C D CostYear1 CostYear2 CostYear3
A1 B1 C1 D1 1000 10000 10000
B2 C2 D2 1000 10000 10000
A2 B3 C3 D3 1000 10000 10000
B4 C4 D4 1000 10000 10000
C5 D5 1000 10000 10000
...

I would need to get the source PivotTable showing to get the final one formated correctly or use a specific function of the pivotTable that I don't know ?
A1 B1 C1 D1 1000 10000 10000
A1 B2 C2 D2 1000 10000 10000
A2 B3 C3 D3 1000 10000 10000
A2 B4 C4 D4 1000 10000 10000
A2 B4 C5 D5 1000 10000 10000
...

Thanks for anyhelp, hope I'm clear enough
Karim from France.

 

[SkipVought]

Hi,

Your problem is right here...

I have a file with multiple informations about costs in 5 different worksheets

If ALL your source data were in ONE TABLE (sheet) then you could do exactly what you want, using the source data only.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[AKarim]

Thanks SkipVought, the reason why I had to create those multiple worksheets is that the calculation of those costs are completely different, I thought about merging, but I can't do it, the worksheet is un understandable afterwards.
Any other clue please ?

 

[SkipVought]

Could you be more descrptive of the differences and similarities?

I assumed that these sheets were like Jan, Feb Mar, but obviously not.

But it is never a good strategy to summrize from a summarization. Some problems can be had.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]