Macro to append values only, not formulas, to the next empty row

Hi,

I'm very new to VBA, the macros that I do have are from internet research and are not something I've built from scratch. I have this macro that I've been working with:

Sub Append_Data_to_Master_List()

Range("b5:f14").Copy Destination:=Range("k" & Rows.Count).End(xlUp).Offset(1)

End Sub

B5:F14 is refreshed with new data and I need to append the new data to the running list in Column K. The problem is that whenever new data appears in B5:F14, all the data that I've logged in Column K refreshes as well, with the new data in B5:F14, instead of keeping the historical data. I'm wondering if modifying this macro to paste values into column K would fix this problem.

If anybody could help me with this I'd appreciate it!

Thanks,

Christina