copying and pasting a dynamic range

Hi, I have successfully copied and pasted a range into another sheet, however, the range is ever-changing as I am using the RAND function in the range. But I have only pasted the values, and of course, these do not change when the range changes.

Is there a way to code this up so the range i pasted changes when the original range changes i.e. when pressing F9?

Here is my code so far below

 WSrandomNumbers.Range("newRandno").Copy
WSinterestRateSim.Range("A8").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone

Thanks for your help and time