How to connect User Form Radio Button to Radio Buttons in Workbook

I am trying to link radio buttons from a userform so that when Option 1 is selected in the userform, Option 1 will also be selected on both Sheet 1 & Sheet 2 of my workbook. When 1 option is selected, the other two options will not be selected. Both Sheet 1 & Sheet 2 should match the option selected in the userform.

I have tried so many diffferent variations of the code below but I'm still missing something. Any help?

Private Sub CommandButton1_Click()

If OptionButton1.Value = True Then _
    Sheets("Sheet1").OptionButtons("Option Button 1").Value = True
    Sheets("Sheet2").OptionButtons("Option Button 1").Value = True
    Sheets("Sheet1").OptionButtons("Option Button 2").Value = False
    Sheets("Sheet2").OptionButtons("Option Button 2").Value = False
    Sheets("Sheet1").OptionButtons("Option Button 3").Value = False
    Sheets("Sheet2").OptionButtons("Option Button 3").Value = False
    
If OptionButton2.Value = True Then _
    Sheets("Sheet1").OptionButtons("Option Button 1").Value = False
    Sheets("Sheet2").OptionButtons("Option Button 1").Value = False
    Sheets("Sheet1").OptionButtons("Option Button 2").Value = True
    Sheets("Sheet2").OptionButtons("Option Button 2").Value = True
    Sheets("Sheet1").OptionButtons("Option Button 3").Value = False
    Sheets("Sheet2").OptionButtons("Option Button 3").Value = False
    
If OptionButton3.Value = True Then _
    Sheets("Sheet1").OptionButtons("Option Button 1").Value = False
    Sheets("Sheet2").OptionButtons("Option Button 1").Value = False
    Sheets("Sheet1").OptionButtons("Option Button 2").Value = False
    Sheets("Sheet2").OptionButtons("Option Button 2").Value = False
    Sheets("Sheet1").OptionButtons("Option Button 3").Value = True
    Sheets("Sheet2").OptionButtons("Option Button 3").Value = True
    

End Sub