Importrange

Thank you All!

This worked for me:
Install time based trigger
copy now() function from one cell to another