How to copy newly added rows in a Source Sheet to a Target Sheet without copying Source columns?

Hi there! 

I have a DataMesh that is set up between two sheets. When I add a new row to the Source Sheet, I would like for the DataMesh to pick up that new row and bring it into the Target Sheet, however, it does not seem capable of doing that. The other method which I have explored is the Copy Row Automation -- this works well up to a point, but the issue with this method is that it brings in ALL of the columns from the Source Sheet, which I do not want in my Target Sheet. 

TLDR: Any ideas on how to automatically copy newly added rows in a Source Sheet to a Target Sheet without also copying over the Source Sheet columns (in other words, copying ONLY the information of the row that matches the columns in the Target Sheet)? I hope this makes sense. Thank you in advance. 

Kindly,

O.O.

Answers