re: RPA or Excel Macro: Copying sheets from one existing workbook to another.

As another poster said, github and google are your friend.

The protecting worksheet thing, select the cells you want to have editable, right click > format cells. Theres a pane in that dialog box that's called "protection", make sure the locked check box isn't selected. In your vba macro, use the following language:

Worksheets("Time Entry").Unprotect "Password"

Your macro

Worksheets("Sheet1").Protect "Password" DrawingObjects:=True, Contents:=True, Scenarios:=True, _
UserInterfaceOnly:=True, AllowFormattingCells:=False, AllowFormattingColumns:=True, _
AllowFormattingRows:=False, AllowInsertingColumns:=False, AllowInsertingRows:=False, _
AllowInsertingHyperlinks:=False, AllowDeletingColumns:=False, AllowDeletingRows:=False, _
AllowSorting:=False, AllowFiltering:=True, AllowUsingPivotTables:=False