I have a workbook that has 9 "Chart" sheets in it. These are Piviot charts for different things. The data that drives the pivot tables is pulled in by an automatic Oracle Query. I need a method to copy these charts and paste them into a Powerpoint presentation.

I have tried inserting an object from the spreadsheet, but when my spreadsheet refreshes (set on a timer) all 9 charts look the same.