Copy pivot table from pivot sheet and paste into another sheet with data in mn

Hello Community,

I am working on scenario where

i have two pivot tables in sheet of excel,i need to copy pivot tables to another sheet , pivot tables values in another sheet should be in millions , Need suggestions.

Thank You

You can use a macro to do that