#REF errors when using paste link in database

This problem arises from the solved problem in this link:
The file serves me well, but when it undergone "minor revision", it went "wild"

The macro is working if the data in the database are inputted manually
BUT when Paste-Link is used, it resulted to #REF errors.

Can you help me?