Sum totals from new sheet data VBA

[silvertyphoon1]

I have a form with a button and list box. When I select and item from the list box and click the button it creates a new sheet with the name from the list box selection, as well as adds the same name selected to another sheet already in existence called (Sheet B). The name is added to the next row down in column B of (Sheet B). I have all of this working fine.

My problem is that when the new sheet is added and the name to (Sheet B), I need to find some way to insert a formula on (Sheet B) column D that takes the sum from the newly created sheet F4:F75. So each time I click the button on the list box the formula is created on (Sheet B). This way when I input numbers on the new sheet I will always have the totals on that (Sheet B).