Looking for help with VBA macro

Hello,

I am trying to write a VBA macro in excel that will do the following:

When the values of the cells in the range B1-B10 of "Sheet 1" are changed (by entering value and pressing enter), the macro should copy the corresponding values from the cell range C1-C20 from "Sheet 2" into an empty row in "Sheet 3". Thus, every time I change the value in B1-B10 of "Sheet 1", the macro saves the data calculated in "Sheet 2" to a third worksheet and collects the saved data.

This is my attempt so far but I'm fairly new to VBA and have not been finding a solution:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("B1:B10")) Is Nothing Then
Sheets("Sheet 2").Select
Range("C1:C20").Select
Selection.Copy
Sheets("Sheet 3").Select
Range ("A1:A20")
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End If
End Sub

Any help or suggestions would be greatly appreciated! Thanks!