data from getpivotdata in specific worksheet or in the multi-dimension array

Hi gurus and experts,

Is there a way to save getpivotdata in a specific worksheet instead of a new worksheet? For instance, when the following code is run, the data saves in a new worksheet.

Please Login or Register  to view this content.

Also can we save the data (from Range(d).ShowDetail = True) in the array instead of saving in the worksheet?

I have attached the template file for your needful. Your advices are much appreciated.

Thank you
Roshan

Thanks Erwin.