I'm getting a little frustrated with this simple problem, but don't
have a lot of time to spend reading massive Excel books to figure it
out. I hope someone can help me!
Here's the goal:

To take data from a cell in Sheet1, paste it into a cell in Sheet2.
If the designated cell already contains data, then paste into the next
empty cell in the same column.

Here's where I'm at:

'CURRENT SHEET SELECT CELL G7
Range("G7").Select
'COPY CURRENT CELL
Selection.Copy
'MOVE TO WORKSHEET "REQUEST LOG"
Sheets("REQUEST LOG").Select
'SELECT CELL C3 IF EMPTY, IF NOT, SELECT NEXT EMPTY CELL IN COLUMN
If IsEmpty(Range("C3")) Then
Range("C3").Select
End If
'PASTE COPIED DATA INTO EMPTY CELL OF COLUMN C (this is where the
problem is)
Selection.Paste