I am a shortcut freak...so, in the cell where you want the information to end
up (Cell D8 in Worksheet B.) press the = keyuse CTRL and go to your source
(Worksheet A, Cell C4), place your cursor on the cell. This should bring up
your friendly blinking dashing line. The HIT ENTER!!!! This will place the
information in the "end up" cell, and you will be on Worksheet B.