Adding row on every Worksheet

[WxShady13]

This may not be possible but I have a table that starts on every Worksheet but 4 (Main, Key, Mail Merge, Balance Tables). Is it possible to have a VBA code add a row to each of the tables on the remaining worksheet? There is the potential that the tables are different lengths but all begin at A9 on the worksheets.

 

[Olukunle]

This may not be possible but I have a table that starts on every Worksheet but 4 (Main, Key, Mail Merge, Balance Tables). Is it possible to have a VBA code add a row to each of the tables on the remaining worksheet? There is the potential that the tables are different lengths but all begin at A9 on the worksheets.

Anything is possible. Make your request clearer please. You can show a sample.

 

[WxShady13]

I have a workbook that has Employee billing data for each employee on a LOA. The table I need to add a row on begins on A9 for each worksheet. Adding the row on every Monday would update the balance due for each employee.