Macro to Insert a row across a range of worksheets

Hello,

I have run into a problem with a Pivot Table overwriting other content when new data is added and refreshed.

This pivot table is included across a range of "Product" worksheets. To resolve this issue I would like a macro to insert a new row below the pivot table , this way when new content is added the pivot table will not overwrite the content below it.

The Pivot Table data is on the "Client" worksheet. Each Product worksheet includes a Pivot Table referencing the the Client data.
I would like to force a user to add a new client data with a macro this way I can force a new row to be inserted across All "Product" worksheets.

Attached is an example.

Thanks in advance for any help.

Matt

Thanks Bernie this is perfect. Is there a way for the focus to land on the Client Worksheet where the new row was inserted?