Pivot table options. Show report filter pages

Good morning,

I am trying to get each sheet in separate books.

What I have done is to use the "show report filter pages" to get each region in a different sheet.

Could you please provide the formula/macro to get each region in different books instead of different sheets within the same book?

Thank you in advance.