Create A Pivot Off a Already made pivot and Copy Paste in Separate Sheet

Hey Guys,

I'm Trying to create a pivot off a pivot and paste in a seperate sheet. I tried recording it but am receiving an error, thus, im hoping I can have some assistance here.

Essentially, we want to go in "Sheet A" The pivot is from Column H to Column Q. We want to report filter for "option A" which includes "A" "B" "C" "D" categories. For Column Labels have "option B". For Row Labels have a breakdown by "Option C". For Values have a breakdown by "Option D" and value field settings to be average.

From this point we'll copy this pivot and paste in "Sheet Z"

Can someone advise?

Thank You

Additionally - this would be reported daily and I want it to refresh based on new data

Help anyone?