I would say that the cell F15 (the sum of F6:F10 ?) has a formula in it which would explain the #REF error.
Hence, try the following:-
ws1.range("F15").copy ws2.range("A" & destrow)
ws2.range("A" & destrow).PasteSpecial xlPasteValues
and in this line:-
Destrow = ws2.cells(rows.count, "A".End(xlup).row + 1
you are missing a parenthesis. Hence change it to:-
Destrow = ws2.cells(rows.count, "A").End(xlup).row + 1
Also, watch your upper and lower cases throughout the code. For example, the sheet names in the code need to be exactly the same as the tab name.
I hope that this helps.