'COPY PASTE TO ANOTHER BOOK

I'm fairly new at script, can anyone help me to write a script; copy paste one cell from one book to another? let say I have the book COPYFROM, SHEET1, cell A1. I like to copy that to book. NEWBOOK, sheet2, cell D5. and every time i do this, the new data should paste on the next row below.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source