Using variables in formulas/ranges

Note: I am pretty new to this, so forgive my mistakes.

I have a worksheet that changes every month. New rows are added or subtracted, so I need to use variables to select ranges.

I have been trying to use variables to select a certain range in another worksheet so I can use it in another worksheet. The code is below. I am getting errors at these two spots:

Let netincome = jan & inloss & ":" & jan & inloss

 ActiveCell.Formula = "=sum('Local Results-F'!" & netincomerange & ")"

Any help is appreciated.

Dim jan As String
        
        With Cells.Find(What:="January", After:=ActiveCell, LookIn:= _
        xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
        xlNext, MatchCase:=False, SearchFormat:=False).Activate
        End With
        
        jan = ActiveCell.Column
    
        Application.Workbooks("88888.xlsx").Close False
        
     ''NET INCOME

    Sheets("Consolidated-F").Activate
    
    With Cells.Find(What:="Net Income (Loss)", After:=ActiveCell, LookIn:= _
    xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
    xlNext, MatchCase:=False, SearchFormat:=False).Activate
    End With

    netinloss = ActiveCell.Row
    
    Dim netincomerange As Range
    
    Let netincome = jan & inloss & ":" & jan & inloss

   Set netincomerange = Range(netincome)
    
    Range("C" & netinloss).Activate
    ActiveCell.Formula = "=sum('Local Results-F'!" & netincomerange & ")"
    
        End Sub

aren't you going to want this to be dynamic so you can make it work for jan, feb...dec? or do you only want to sum net incom (loss) for january?

it is best to post a sample workbook, but take out any sensitive info and replace it with dummy data, hit the go advanced button and click the paperclip to attach a file

try something like the following which asks the user to input the month to be summed with an input box, then uses the search function to search for the appropriate month and sums the Net Income (Loss)

here's a copy of the workbook with the macro and a form button to run it NIL example.xlsm

HTML Code: