Making Multiple Tables Have The Same Amount of Rows Using Excel VBA

Hello,

In my Excel workbook, I am linking specific data from my main table in the 'Main Sheet' to my two other tables in the 'Summary Sheet' using functions . The two tables in the 'Summary Sheet' represent two different status levels. In the 'Main Sheet', I currently have a macro that recognizes the event at which a row has been inserted or deleted in the main table. I need to develop a macro so that when a row is inserted or deleted in the main table in the 'Main Sheet', it will insert or delete that corresponding row in the two tables in the 'Summary Sheet'.

I have attached a simple version of the Excel file I am working on to this post which should greatly help in understanding what I am trying to accomplish. The macro in the 'Main Sheet' that recognizes the event at which a row has been inserted or deleted in the main table has been implemented in the Excel file I attached to this post. This macro would be used to call the macro I am trying to develop in the other worksheet. Also, I explain the function of the macro in the Excel file.

Thank you for taking your time to read my post. Any help would be greatly appreciated.