#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 Extending Google Sheets

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 Extending Google Sheets