Modification of Amit Agarwal's code that clones the entire dataset from the source spreadsheet, appends the new rows of data to the target spreadsheet and deletes the previous rows so that only the newest rows remain in the target spreadsheet. This script can be executed automatically when the time trigger is set for each function.
Amit Agarwal's code can be found here: https://www.labnol.org/code/20239-copy-google-spreadsheets