Unable to copy data from another workbook while in working current sheet
You have a typo. What you want it to be ...
... what you've got/assigned ...
To help you in the future, put Option Explicit at the top of your module. That will ensure you've correctly initialised all variables.