You don't link frames or other controls to sheets, you write code for the
individual controls that does whatever you want it to, including putting
information into worksheets of your choosing.
In the design environment, double-click on the control you want to process,
then write the code to handle the information from that control.
This can include accessing a sheet by name. E.g.
Option Explicit
Private Sub TextBox1_Change()
Worksheets("Jim").Range("A1").Value = TextBox1.Value
End Sub