I'm currently trying to create a macro that will take updated information in one sheet and automatically update the next sheet. So far I have made it so it will update one cell...how do I make it so it will update all of the cells? Should I run a loop, or is there a way to change the range to include all of the cells? Needless to say, I have zero experience with VBA haha. Below is the code I currently have.

Private Sub CommandButton1_Click()
Dim CustomerName As String


Worksheets("Sheet1").Select
CustomerName = Range("C4")
Worksheets("Sheet2").Select
Worksheets("Sheet2").Range("C4").Select
ActiveCell.Value = CustomerName
Worksheets("Sheet1").Select
Worksheets("Sheet1").Range("C4").Select


MsgBox "Updated!"
End Sub