Slowest Macro ever - Please Help! Copy Paste

[Caveman1964]

I have written this over and over again. Its takes 30 seconds. I am a novice doing this a few months.
I should be defining...tried that but could not get this to speed up. It works but looks embarrassing, I am aware.
After a couple of days of trying to speed it up, I am turning to the Guru's once again.
please review and tell me why this is so slow. I so appreciate any help or rewrite.

Sub SubmitDataNewEntry()
'unprotect
Sheets("Do Not Alter").Unprotect "1"
Sheets("Data Collection").Unprotect "1"
Sheets("Complaint Entry").Unprotect "1"


Sheets("Do not alter").Rows(7).Copy
Sheets("Data Collection").RANGE("A7").End(xlDown).Offset(1, 0).EntireRow.Insert

Sheets("complaint entry").RANGE("e5:e22").Copy
Sheets("data collection").RANGE("A7").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True


Sheets("data collection").RANGE("l7:l2500").Copy
Sheets("data for dashboard").RANGE("a77").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Sheets("Complaint entry").Activate
RANGE("e5:e22").ClearContents
RANGE("E5").Select


ActiveWorkbook.Save
'Protect
Sheets("Do Not Alter").Protect "1", True, True
Sheets("Data Collection").Protect "1", True, True
Sheets("Complaint Entry").Protect "1", True, True

End Sub

 

[mumps]

See if this makes a difference:

Sub SubmitDataNewEntry()
    With Application
        .ScreenUpdating = False
        .Calculation = xlCalculationManual
    End With
    Dim ws As Worksheet
    For Each ws In Sheets(Array("Do Not Alter", "Data Collection", "Complaint Entry"))
        ws.Unprotect "1"
    Next ws
    With Sheets("data collection")
        Sheets("Do not alter").Rows(7).Copy .Range("A7").End(xlDown).Offset(1, 0)
        Sheets("complaint entry").Range("e5:e22").Copy
        .Range("A7").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
        .Range("l7:l2500").Copy
        Sheets("data for dashboard").Range("a77").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
    End With
    Sheets("Complaint entry").Range("e5:e22").ClearContents
    For Each ws In Sheets(Array("Do Not Alter", "Data Collection", "Complaint Entry"))
        ws.Unprotect "1", True, True
    Next ws
    With Application
        .CutCopyMode = False
        .ScreenUpdating = True
        .Calculation = xlCalculationAutomatic
    End With
    ActiveWorkbook.Save
End Sub

 

[Caveman1964]

Thank You!

 

[mumps]

You are very welcome.