Macro to only allow data to be copy pasted based on data validation criteria

Hi everyone.
I am trying to find a macro that will only allow data to be copy pasted based on data validation criteria.
The user can only enter the following English characters - alphabets (upper and lower), numbers, period, comma, forward slash, hyphen and apostrophe. And with the help of the forum members, I managed to get this formula.
My next task is finding a code where the user is able to copy paste data which satisfies all the above mentioned criteria. If it doesn't, is it possible to have a macro do this? Also, I need the macro to run when the sheet is opened, or force the user to have macros enabled.
I have attached a sample file, with the data validation criteria. (The data validation applies only to rows A8: F207.) I have tried various codes but nothing seems to work. I can't prevent the user from copying and pasting completely, as the sheet usually consists of 5,000 rows worth of information, which will be an absolute pain to type out.
Thank you for any help you can provide.

Bump no response

Hi everyone.
I am trying to find a macro that will only allow data to be copy pasted based on data validation criteria.
The user can only enter the following English characters - alphabets (upper and lower), numbers, period, comma, forward slash, hyphen and apostrophe. And with the help of the forum members, I managed to get this formula.
My next task is finding a code where the user is able to copy paste data which satisfies all the above mentioned criteria. If it doesn't, is it possible to have a macro do this? Also, I need the macro to run when the sheet is opened, or force the user to have macros enabled.
I have attached a revised sample file, with the data validation criteria. (The data validation applies only to rows A8: F207.) I have tried various codes but nothing seems to work. I can't prevent the user from copying and pasting completely, as the sheet usually consists of 5,000 rows worth of information, which will be an absolute pain to type out.
Thank you for any help you can provide.