I need an excel help

Job ID: 34391240

Budget: €12 – €18 EUR

So I have different spreadsheets. And the cells includes a formula which includes pivot table tab . We need to retain the data in the cells without having the pivot formula in them. Like we need to get the data of a huge pivot table without using the formula of pivot, ANY IDEAS?
Related categories: Visual Basic Data Processing Data Entry Excel