Add row in one worksheet, automatically adds a row in other worksheet

[Roby117]

I have a workbook that has four tabs ( Apples, Oranges, Peaches and Master) . Apples, Oranges and Peaches tabs have columns (Date, name, count, price per unit, total price )
while master has just one extra column that is fruit

I want that if I add a row in either of the Apples, Oranges or Peaches tab, a row is added to the master tab at the end

How can I achieve this

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Add row in one worksheet, automatically adds a row in other worksheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.