RunTime error 1004 when trying to reference a worksheet in a different workbook and assign it to a variable

i'm trying to work with two sheets in two different workbooks.
For some reason this code returns an error

this assignment returns an object that is empty for Source when i inspect it using watch
Destination however seems to work well -for now!

for some reason the last line gives a runtime 1004 error (method 'Range' of object '_global' failed)
And the cells are referring to the Source sheet not Destination.
what is wrong in my code


View on Stack Overflow