Add/copy row in one sheet when another sheet is copied/pasted using VBA

I have one sheet for calculating parts with four different vendors.
I often need more sheets to calculate in for different projects so i added a commandbutton for copy/paste the sheet i just used an reset user input after copied.
This works great.

But i also have this other sheet that sums up all prices from the "part" sheets.
when i push my command button "add sheet" the sum sheet ned to add new rows representing the new sheet added for the four different vendors.

the existing four rows that all have cell addresses in them to the existing sheet "parts 1" is B5, B22, B39 and B56.
The new added cells should be B6, B23, B40 and B57.

example. sheet totalt, cell B5 have

Please Login or Register  to view this content.

when new row is pasted it should have

Please Login or Register  to view this content.

Sums up sheet is named total
My first sheet with parts is named: parts 1
if i use my cmdbutton the next will be named parts 2, and the next parts 3 ..