Copy table dynamically but PIVOT table does not seem the right way to go

Hello Forum.
I have been making accounting for my building for 7 years (unprofessionally)
I have my excel table that works fine but I have copied and pasted many formulas manually in all sheets.
+ instead of having tables that grow as expenses are entered, I created tables with 100 lines which makes it ugly when printing unused empty cells.
So I am trying to rewrite the whole thing.
I discovered the tables (better late then never) and when I hit TAB, it adds a new line before the total.
Neat.
Then I used a VBA formula to copy the table in the next row.
Thing is I want to copy the GLOBAL expenditure table to all sheets (7 sheets representing each apartment) but I would like the amount to be split according to the percentage held by each apartment owner

0_Form_Excel.png

I used a VBA to copy the expenditure table

Sub copedonnees()
Range("a14").CurrentRegion.Copy Feuil2.Range("a14")
End Sub

With this macro, I have a problem because my table of income will grow.

What I want to achieve:
1) to 'replicate the GLOBAL spending table on all sheets
2)To apply the individual percentage of the GLOBAL spending to each individual sheet.

Thank you
Eve

PS I tried with Pivot table with no luck as this is more to analyse data ?????