Cell linking

I've been testing cell linking and it's not working as I expect. I was hoping that if I select the cells in a destination sheet, and link to the cells in the source sheet, that when a new submission (row) to the source sheet was made, it would automatically show the data in a new row in the destination sheet. However, it seems the data doesn't show up in the destination sheet until I link to the source sheet again for the next row in the destination sheet. What am I missing? Why isn't it creating the new row in the destination sheet? I did select many rows in the destination and source to create link and did refresh the source sheet and destination sheets.

Best Answer