After creating sheets and arrange them on different folders under Sheet Index the Sequence number is set to count all sheets in all folders.

Please add the property of the Sequence number that count only inside the folder and restart to 1 on the next folder - screenshot attached for the required values.