I pasted a linked picture of a selected group of cells (defined by $GA$2:HE$3) from workbook "TestWorkbook" within tab "Tab1" to a different excel workbook.

The equation defining my linked picture in the new workbook looks like this:

='[TestWorkbook.xlsm]Tab1'!$GA$2:$HE$3

My goal is to create a button that -- when pressed -- will shift what is displayed in the linked workbook to the right one column. In essence, pressing the button would permanently change the linked picture equation to the following:

='[TestWorkbook.xlsm]Tab1'!$GB$2:$HF$3

If I then pressed the button again, it would once more add an iteration to the column values resulting in the following:

='[TestWorkbook.xlsm]Tab1'!$GC$2:$HG$3

Is there any way to program a button that will do this?