Creating Pivot table from Multiple sheet

[bunts011]

Hi,
I am trying to create Single Pivot table from three sheets. all sheets have Table Header, Data for first few Columns are same in all three sheet, the Value and Currency is different. When I am trying to create Pivot table using Powerviot I am getting error: The relationship cannot be crated beacsue each column contains duplicate values.
Can you advise how would I fix this issue.

[stasinek]

like this: https://www.youtube.com/watch?v=ZBn1-r0I5oE

[Keebellah]

I would suggest to create a new table where all data is together and use that table.
You could do this on-the-fly with a macro