Hi i have a spreadsheet that links to an online data source that is updating on a regular basis.
Can someone tell me how i can copy and paste these updates into a separate tab or separate spreadsheet altogether?

Updating spreadsheet has 10 rows of data that is updated every minute.
I would like this data to be collected on the 2nd spreadsheet without erasing the previous cut/paste etc. So that over time this spreadsheet will have 100's of rows of data.

thanks in advance.