Insert a row on two tabs - but not in the same line location

[Art3mis]

Hey! I have an excel spreadsheet with two tabs that have corresponding information. When I insert information on the first tab it automatically autofills on the second. However, if i insert a new row on the first tab to add information, a new row will not pull up on the second tab. To combat this i am looking to create a macro that will insert a row at any given point on the first tab and equally insert a row on the second tab that will automatically autofill the formulas from above. However, I am not sure how to do this as the two inserted rows are not on the same line as each other.
Can anyone show me a macro that can do this?

 

[sijpie]

How will the macro know where to insert a row on the 2nd tab? Does it need to look for the row with the same information as the row above the inserted line on the 1st tab?

 

[Art3mis]

Thanks for responding. I actually reworded this question in a different thread - because of the reasons you mentioned - and got a great response.
That thread can be seem here: insert rows in table above specific cell value