PDF generated list order

Hi

I have a small problem in the ORDER that my pdf's are generated compared to the way this order is displayed on my main front sheet.

My code loops through and checks for topics on which a candidate scored than 75% on a variety of topics. It then produces 10 pdf's on those topics only with a main cover page.

The problem I have is that order of the pdf names on the front page is NOT in the same order as when they are generated. This confuses the candidate who could see e.g. "Bears.pdf", "Dogs.pdf", etc. on the front page but the 1st pdf in the booklet could be "Cats.pdf". Could I possibly add a number at the beginning of each pdf (e.g. 1,2,3 etc.) so that they are in the same order as the ones displayed on my main front sheet?

Here is the code for the main front page with the order of the pdfs being displayed.

Please Login or Register  to view this content.

Here is part of my loop code to generate the pdfs

Please Login or Register  to view this content.

I hope the above makes sense. Still new to this and still learning. Any help would be greatly appreciated.

TIA

I have added some photos to illustrate my problem further as I am still having no joy with this.

Basically I need the order of the pdf's (in my folder) to be the same as the order on main page sheet (shown in the table picture attached).

I think a simple count (1., 2., 3., etc) added to each file name (which corresponds to the order of the list on the main page sheet) may work but not sure how to add it to the code above in post #1.

Can anyone help please?