I have a worbook with 2 sheets named AA and BB.

I have to add several sheets sometimes 3 ,6 or 7 OR 12 sheets with their sheets names e.g AC , DE, FG, VF, DE, MC, VV etc after sheets BB

but sometimes there may be 4 or 5 or 6 or 7 named sheet after sheet BB but need to add additional sheets names after the last existing sheet


looking for vba code to do this .

Can anyone assist