If the project aims to transfer data from one sheet to another, automation could be a viable solution. However, there is a requirement that both sheets must be identical in order to facilitate the data transfer. At present, there is no available option for field attribute mapping, which would allow us to perform mapping and copy the data.
Another concern related to the aforementioned situation is that when you copy the data, it only transfers successfully the first time. If you want to edit or delete a line item in the future, those changes do not reflect in the new sheet where the data was copied. Ideally, both sheets should allow for deletion and editing of the data.