Excel - automatically add row, once the cell is populated in another Sheet

In Sheet1 I have columns A and B. Those are empty.
In Sheet2 I have columns A,B,C as well. In Sheet2 A and C columns are ppoulated, while B column is empty, and users need to populate this manually.

Once I populate the B column in Sheet2 for any of the existing rows, I should copy that row with A and B values and paste it to the Sheet1, by creating a new row in Sheet1 for A and B columns with same values ( A and B columns) from the Sheet2.
That Sheet1 has some different calculation that should be kept in separate sheet, so I must make this kind of automation for creation of new row.

Is this feasible somehow?

This will look something like:

Private Sub Worksheet_Change(ByVal Target As Range)

    'Something changed, was it in column B?
    If Not Intersect(Target, Sheet2.Range("B:B")) Is Nothing Then
        'The change was in column B.
        'Lets figure out the last unused row in Sheet1
        lastRow = Sheet1.Range("A" & Sheet1.Rows.Count).End(xlUp).Row + 1
        
        'Now we will grab our values from A and B and stick them in Sheet1
        Sheet1.Range("A" & lastRow).Value = Target.Offset(, -1).Value 'col A for the row that changed
        Sheet1.Range("B" & lastRow).Value = Target 'col B for the row that changed
    End If
End Sub

That goes in to Sheet2's code page.

In Excel 365 or Excel 2021, a FILTER formula should do the trick (see here for help).

=FILTER(Sheet2!A:B, NOT(ISBLANK(B:B)))

This creates a 2-column-wide spilled range wherever you type this formula.<br/>Then, to build other formulas from the spill range, you can refer to the method/formulas I had typed in that other answer.