Can you be a little more specific ?

Any time you click into, tab into or hit the enter key, the cell you go into becomes the selected cell, there are over 17 billion cells on each worksheet. How would VBA know which one(s) you want this copy to happen with, and how would VBA know what cell on which other sheet you want to paste to ?