#Short answer It's not possible to use Google Sheets built-in functions to copy data, but Google Sheets could be extended by using add-ons and Google Apps Script #Explanation Google Sheets built-in functions can only calculate data. You could manually copy and paste those values but for to do that automatically it's required something else. You could explore the available add-ons in order to find one that fit your needs or use Google Apps Script but it requires programming knowledge. There are a lot of examples in this site that could help you. Start by taking a look to linked questions in the related section on the right panel of this page. #References [Use add-ons and Apps Script][1] [Extending Google Sheets][2] [1]: https://support.google.com/docs/answer/2942256?hl=en [2]: https://developers.google.com/apps-script/guides/sheets