Here is the scenario:

I have multiple worksheets in a workbook each containing 2 charts side by side + headings in A1. I would like to have a button in a front sheet to click and extract 1 chart from each tab + respective headings.

Please let me know if this is possible? I have tried searching the net and had no luck thus far.

Regards.