vba specific text copy to another tab
<p>Having issues with some vba, if anyone can point me in the right direction it would be greatly appreciated, currently my code is returning a full row of data and it is returning multiple rows, this is my current code.</p>

<pre><code>    Sub BUTTONtest_Click()
Dim c As Range
Dim j As Integer
Dim Source As Worksheet
Dim Target As Worksheet

' Change worksheet designations as needed
Set Source = ActiveWorkbook.Worksheets("Two Years")
Set Target = ActiveWorkbook.Worksheets("Two Years League")

j = 3     ' Start copying to row 1 in target sheet
For Each c In Source.Range("G6:K6")   ' Do 50 rows
    If c.Text = "OVER" Then
       Source.Rows(c.Row).Copy Target.Rows(j)
       j = j + 1
    End If
Next c
End Sub
</code></pre>

<p>I need to look at each row and in each row if the word "OVER" appears I need it to return the information in the side bar e.g. column B I would need this to apply for each wee section e.g. Column C- F should return the number from column B and H-K should return G etc.</p>

<p><a href="https://i.stack.imgur.com/VnCaX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VnCaX.jpg" alt="enter image description here"></a></p>