I'm not sure if I fully understand your query but I assume that you would like to randomly select a cell from Column C in the "Config" sheet and automatically transfer the cell value to Column F in the "Merger_Pole" sheet. If I have assumed correctly, then the following code may work for you:-
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 3 And Target.Cells.Count = 1 Then
Target.Copy Sheet1.Range("F" & Rows.Count).End(3)(2)
Application.CutCopyMode = False
Application.EnableEvents = True
The code is a Worksheet_SelectionChange event so as soon as you click on a cell in Column C of the "Config" sheet, the cell value will be transferred to Column F in the "Merger_Pole" sheet.
Following is the link to a little sample that I have prepared for you:-
In the "Config" sheet, select any cell in Column C to see its value transferred to the "Merger_Pole" sheet.
To implement the code into your workbook, right click on the "Config" sheet tab and select "View Code" from the menu that appears. In the big white field that then appears, paste the above code.
Please test the code in a copy of your workbook first.
I hope that this helps.