How do you copy and paste between workbooks using vba?
Try recording a macro doing it and see what the macro looks like. Then youcan adapt the code to do just what you want.