Get values from varying rows and columns of Pivot Table and enter those in different table

Hi Experts,

I wrote VBA / macro to fetch rows, column and its corresponding values from pivot table. Am still learning and thought of giving it a shot. It's working pretty well but don't know how to fetch the records if number of rows or columns increase. I will be glad and appreciate if I get help on this.

Also how to get names of multiple charts and save them as image (like copy --> Paste as image in JPEG or PNG format from VBA)

Also please let me know if there is a better way of coding or code optimization.

Please find the attached file.

Regards,
Richa