vba code to add modulable no of named worksheets after the last existing named sheet

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

Thanks the third option was the most appropriate what I was looking for