Seeking for VBA code that can insert rows in two different ranges

[Mysore]

Hi Friends

Attached is a sample workbook which has two tabs called "Report" and "Data".
The Data sheet holds two tables namely "Rates" and "Qty" which are manually updated and the report sheets summaries the results . I need a macro to insert rows in the Qty table when there is a new row inserted in the rates table. The same should occur to the Reports sheet as well.
Any help is much appreciated.

Cheers
Mysore