I currently have some code written to copy and sheet and rename the new sheet to whatever the user enters in on UserForm2 TextBox1. I now need a way to update a total formula when a sheet is added like the formula below to include whatever name is used.

B27+F27+J27+"whatever name the new sheet is"!B27+"whatever name the new sheet is"!F27+"whatever name the new sheet is"!J27 and so on.