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
[TABLE="width: 375"]
<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>[TR]
[TD="width: 147, bgcolor: #D9D9D9"]Customer[/TD]
[TD="width: 121, bgcolor: #D9D9D9"]Customer Type[/TD]
[TD="width: 116, bgcolor: #D9D9D9"]Agreement Date¹[/TD]
[TD="width: 116, bgcolor: #D9D9D9"]Actual Live Date³[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 1
[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="bgcolor: transparent"]05/01/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 3[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="width: 116, bgcolor: transparent"]10/20/2017[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 4[/TD]
[TD="bgcolor: transparent"]Indirect
[/TD]
[TD="bgcolor: transparent"]04/02/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 5[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="bgcolor: transparent"]07/02/2018
[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]


All Agreements Tab
[TABLE="width: 528"]
<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>[TR]
[TD="width: 118, bgcolor: #D9D9D9"]FI[/TD]
[TD="width: 121, bgcolor: #D9D9D9"]Customer Type[/TD]
[TD="width: 116, bgcolor: #D9D9D9"]Agreement Date¹[/TD]
[TD="width: 116, bgcolor: #D9D9D9"]Actual Live Date²[/TD]
[TD="width: 116, bgcolor: #D9D9D9"]First Contribution Received Date[/TD]
[TD="width: 116, bgcolor: #D9D9D9"]Receiving Excel Contribution Files[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 1[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="bgcolor: transparent"]05/01/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 2[/TD]
[TD="bgcolor: transparent"]Direct[/TD]
[TD="bgcolor: transparent"]10/17/2016[/TD]
[TD="bgcolor: transparent"]11/04/2017[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="width: 116, bgcolor: transparent"]11/04/2017[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 3[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="width: 116, bgcolor: transparent"]10/20/2017[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 4[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="bgcolor: transparent"]04/02/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Customer 5[/TD]
[TD="bgcolor: transparent"]Indirect[/TD]
[TD="bgcolor: transparent"]07/02/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]