Zend certified PHP/Magento developer

Linking table columns to auto populated

I have 2 tables on 2 different sheets (Table 1 on sheet 1 & Table 2 on sheet 2). I want to enter my information into table 1 and have that information automatically populate a new row into table 2. I forced the relationships to work by linking the first row of cells to table 1, but table 2 doesn’t show the new row unless I drag the table down. How can I have the new row of table 1 show as a new row in table 2 automatically without the user having to do it?