Copying grand total from pivot report

I receive a pivot table every hour that has 12 columns, which at the bottom has the built in Grand Total function. What I would like to do is copy that Grand Total line (which would have 12 cells) and paste it into another workbook. The problem is the pivot table keeps getting bigger as each hour goes by because it creates another new row every hour.

Does anyone know if that's possible with a macro?