Hello,
I created several spreasheets (4)  around project and I set it as dashboards.
Now I would like to take some data in each one in order to create an overview.
I know I can recreate them all but it's a assle. 
I tried to copy/paste them on a new spreadsheet but it just paste the data without the formulas and more importantly without the pivot date linked to them.

So is there a way to insert pivot view from a spreasheet to another or is there a way to directly merge 2 speadsheets ?