Copy an existing worksheet and carry totals to a master worksheet

I would like to copy an existing worksheet and paste it. Using the default
naming for example "Earned Income Method 1" and when copied "Earned Income Method 1 (2)". When this is pasted I would like a row to be inserted into the master worksheet for example "Family Totals" and the total from cell H38 in "Earned Income Method 1 (2)" to carry over into the "Family Totals" worksheet into a new cell of B4.

This is what I was using before in my VBE

Please Login or Register  to view this content.

however instead of new sheet being inserted I want users to be able to
copy/move the sheet then paste and have the new total carry forward to the master worksheet.

Any help would be greatly appreciated,
Confused Roxy