Paste Special Macro issue or macro look up issue

I have updated my macro above to possibly help provide some additional feedback. I have modified the .csv file that I normally import to a .xls file. I have modified the entry screen to accept the file as an .xls file. I hope this alleviate any concerns that my original post may have caused.

Please let me know if you need any additional information.