Add/Update Data from One Tab to Another

[kabijenn]

Hello experts! I've seen several threads on this topic but none that answers what I need! Below is a sample workbook (in the original workbook there are several other tabs, as well as several other columns within the two sample tabs included here; what I included were the columns that I would like automatically updated). I would love to know/figure out how to do the following:

1. When I add rows to Pending Implementation tab, excel will automatically add those rows to the All Agreements tab.
2. When I update cells in the Pending Implementation tab, excel will automatically update the appropriate cells in the All Agreements tab.

Also, All Agreements tab will have more rows than Pending Implementation tab. I periodically remove rows from the Pending Implementation tab.

Thank you in advance!!!!

Pending Implementation Tab

Customer	Customer Type	Agreement Date1	Actual Live Date3
Customer 1	Indirect	05/01/2018
Customer 3	Indirect	10/20/2017
Customer 4	Indirect	04/02/2018
Customer 5	Indirect	07/02/2018

<colgroup><col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;" span="2"> <tbody> </tbody>

All Agreements Tab

FI	Customer Type	Agreement Date1	Actual Live Date2	First Contribution Received Date	Receiving Excel Contribution Files
Customer 1	Indirect	05/01/2018
Customer 2	Direct	10/17/2016	11/04/2017		11/04/2017
Customer 3	Indirect	10/20/2017
Customer 4	Indirect	04/02/2018
Customer 5	Indirect	07/02/2018

<colgroup><col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4315;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;" span="2"> <col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;" span="2"> <tbody> </tbody>