The trick is that the sheet that is inserted must be placed between the start
and end sheets. If it were me I would hide both the start and end sheets so
that no one tampers with them or moves them around. Can you post your insert
sheet code so that we can get an idea of what exactly you are up to...
--
HTH...

Jim Thomlinson


"J.W. Aldridge" wrote:

I have found the vb code to allow me to insert sheets based on names
from a list. Next, I found the code that will allow me to add the same
cell values from each sheet: { SUM(START:END!C5) ]. My problem is, when
I add sheets to a workbook from the list, I want the sheet labled "end"
to remain in its place at the end so that my formulas can calculate
from "start" (add all the sheets up until) "end".

Is there any way possible to do this?