Thanks for you help Naveed. This is the code I was trying to produce.
Sub LoopthroughWorksheets()
Dim sheet_name As Range
Dim sheet_name2 As Range
Set sheet_name2 = Sheets("WS").Range("F:F")
' NEW
Dim counter As Long
counter = 1
For Each sheet_name In Sheets("WS").Range("C:C")
If sheet_name.Value = "" Then
Exit For
Else
With Sheets(sheet_name.Value)
.Range("K1").Value = Sheets(sheet_name2(counter, 1).Value).Range("A14").Value
' NEW ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
counter = counter + 1
End With
End If
Next sheet_name
End Sub
Bookmarks