Copy Value From Destination

Hello, I'd like to copy the value of the destination vs. the formula in column A2:A. See my code below.

Sub ConsolidateData2()
Dim LR As Long
With Sheets("RawStampData")
LR = .Range("A" & Rows.Count).End(xlUp).Row
.Range("A2:A" & LR).Copy Destination:=Sheets("ConsolidatedData").Range("A" & Rows.Count).End(xlUp).Offset(1) 

LR = .Range("o" & Rows.Count).End(xlUp).Row
    .Range("o2:o" & LR).Copy Destination:=Sheets("ConsolidatedData").Range("j" & Rows.Count).End(xlUp).Offset(1)
End With
End Sub