I have a formula that pulls data from another worksheet and I set up two Option Buttons to select which column to choose the data from. The formulas that I need to change are in a non-contiguous range of cells but all need to change from Column D to Column F and vice versa.

So, if Option Button 1 is selected, change all formulas to point to Column D, and if Option Button 2 is selected, change all formulas to point to Column F. Since the worksheet names contain both letters D and F I was unable to find a solution to change only the column without also changing the worksheet name.