Sorry, that doesn't really help as there's no data.

If I run the code on the worksheet it's just copying blanks.

I can understand that the data might change, but what is it you actually want to copy and where do you want to copy it to?