Offset from the precedent in formula in another Sheet

Numerical sheets refer to "base" sheet. I would like to have a formula or other vba which allows me to find a value in Base and return it in the numerical sheet.

F2 in "1" = F2 in "base" - I need to insert K2 from "Base" into J2 in "1"
F2 in "2" = F26 in "base" - I need to insert K26 from "Base" into J2 in "2"
F2 in "3" = F51 in "base" - I need to insert K51 from "Base" into J2 in "3"

And so on - the 25 row gap is constant.

Any help would be appreciated

steve

Sub ProcessStuff()
    Dim ws As Worksheet
        For Each ws In ActiveWorkbook.Worksheets
        If Not IsNumeric(ws.Name) Then GoTo NextSht
        ws.Select
        Call GetRngColF
        Call DoOffSet
NextSht:
    Next ws
    Sheets("Base").Select
   
End Sub
Sub GetRngColF()
    Dim RngColF As Range
    Set RngColF = Range("f2", Range("f" & Rows.Count).End(xlUp))
    
End Sub
Sub DoOffSet()
    With RngColF.Offset(, 4)
    .FormulaR1C1 = "=Offset(precedent(Rc4),0,5)" 'this is where I want to access the precedent in Base
    .Value = .Value
    .NumberFormat = "0.00"
    End With
End Sub