Maybe

Masterbook.ActiveSheet.Range("A:D").Values= Tempbook.ActiveSheet.Range("A:D").Values
VBA Noob