Copy cells from a table to another table with conditions.

Hello everyone.

I am trying to build an Excel script that basically follows the next steps:

1. Look for the last row added to the table.
2. Search for questions that have been answered as "Yes".
3. If it founds a "Yes" value, it must copy the cell right next to it to another table, which is the answer given by the user. And also the name, nationality and age.

Original Table (picture 1):

Table 1.jpg

Expected Table Result (picture 2):

Table 2.png

Here is the Excel file.
Survey Trial (1).xlsx

I will be very attentive to your answers. Thank you in advance.