Macro code not creating data

In the attachment, I have a pivot table with macro, when i run, it creates three files i.e West, South & North, at
c:\izhar, but the problem is, there is no data in these three files, i need help in this regard.

Thanks M. SKTNEER for your solutions