Excel VBA How to detect if something was pasted in a Worksheet

I'll start by saying that my experience with Excel and VBA is limited to what I saw in school. I have programming experience, but in other languages. I have a file that I get every week. The struc...