• Have One Google Sheet where staff can only View
• Have One google Sheet where Admin can type and edit while it transfers the data to that view only google sheet.

I am trying to have the data transfer from one sheet to a completely separate sheet if possible without copy and paste. I am wondering how to get this done, if possible. I know it seems strange but if anyone has any idea, please let me know. Thanks!