Cómo extraer dos Hojas de cálculo en una tabla dinámica

[Camirxp]

Necesito extraer dos Hojas, son muchos datos y de esas dos bojas hacer una sola tabla dinámica, sin que los sume o cuente ni calcule , solo que los extraiga como datos . Se puede ?

[#2]

@Camirxp 

Create a Pivot Table from Multiple Sheets

Create a Pivot Table using data from different sheets in a workbook, or from different workbooks, if those tables have identical column structures.

I would be happy to know if I could help.

I wish you continued success with Excel

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.