Can I have a complete linked cells row by a same combo box placed in different sheets

My question is if its possible have a row of linked cells according to a Combobox that through a Macro develop different sheets from where each of the new Combobox will have a value which I want to linked in the cells row.
Then: the VB from Combobox in the Macro Template My question is if its possible have a row of linked cells according to a Combobox that through a Macro develop different sheets from where each of the new Combobox will have a value which I want to linked in the cells row.
Then: the VB from Combobox in the Macro Template

[I]Private Sub ComboBox1_Change ()[/I][I]Worksheets ("Overview").Range ("M9").Value = Me.ComboBox1.Value[/I][I]End Sub[/I] [size=14]

The idea is to set the next values from the created ComboBox1 in the other sheets. Down “M9” all down the “M” row.

[/SIZE]