Generate workbook deck from multiple pivots in same workbook

[Miratshah]

So I have a workbook which has 3 worksheets. 1st - Raw data. 2nd - Pivot from 1st sheet and 3rd - Pivot from 3nd sheet.

Both pivots have different formats though base raw data is in 1st sheet. Also note that both pivots have a common "FILTERS"

The requirement is to generate a deck of 3 sheets in a separate workbook for each filter in both Pivots. (filters in both the pivots are exactly same). I.e. Raw data for that filter in sheet 1, filtered Pivot 1 in sheet 2 and filtered pivot 2 in sheet 3.

Is there a way to achieve this?

Thanks.