Checking If Worksheet Is Added In Another Workbook With VBA

My company uses two excel workbooks to track campaigns, I'm looking to create a VBA script that can detect when a new worksheet is added to the other workbook when it is activated. To provide a more concrete example:

In workbook one there are worksheets : Apple, Orange, and Pear

In workbook two there are rows Titled: Apple, Orange, and Pear. Each row has formulas that pull from the specific worksheet.

Then a 4th worksheet, Grape, is added to workbook one. I'm aiming to make a script/button which when activated would notice that there is not a corresponding row named Grape and create one.

However, more simply, I could also make this work if I could just create a Script which when activated populated a column in workbook two with all the worksheet names from workbook one.