Try this quick one:

- first activate the current sheet.
- Cell(4,4) would be:
Activesheet.cell("D4").value= sheet1.cell("A1").value

and so on.

Good Luck