Copy info from one excel sheet to another sheet

Hello,

I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have sheet 1 that i call "FORM" that I enter information into. I am trying to create a macro to copy the info that i put on the FORM onto sheet 2 "LOG". When moving the information from the FORM to the LOG, I would like to log it in order. Then after it is entered into the LOG, i would like to protect the LOG so that it cannot be changed until the end of each year. I would also like the FORM to print after i press a command button on the FORM to enter the information on to the LOG. I have the form and log created and have attempted to work with recording my own macro but it just doesn't seem to be working properly.

This is what i have for my macro, but i get this response in a pop up:

Runtime error '1004'
Application-defined or object-defined error

Sub Macro1()
'
' Macro1 Macro
'

'
ActiveSheet.Unprotect
Sheets("FORM").Select
ActiveCell.Offset(-5, 34).Range("A1:N1").Select
Selection.copy
Sheets("LOG").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveCell.Offset(1, 0).Range("A1").Select
Sheets("FORM").Select
ActiveWindow.ScrollColumn = 1
ActiveCell.Offset(3, -30).Range("A1:AB1").Select
End Sub

Thank you so much in advance for your assistance!