Apply formulas on row Addition/deletion

Hi Guys,

I want to write a macro on row addition/deletion. please refer to attached file:

I have a raw data which will be updated in "Incidents" sheet of the file. my requirement is:
1. based on this raw data create table as shown in "IncidentMetrics" sheet.
2. whenever user adds/removes row from this sheet tables created in step 1 should be updated.
3. based on these tables line chart should be created

I am looking to automate report generation based on the data modification.

guys, any direction in this context is highly appreciated.

Thanks in advance.