Need to update progress bar from manual progress % to automatic running %

Dear Expert,

I've attached a file in which I've prepared a final version of the report dump using row data from supporting worksheets. I added a progress bar to my vba coding and didn't know how to connect it to my vba coding in running percent done, so I inserted a manual progress bar in the vba code steps using the google searched code. The progress bar and the code are both working, but the code is still slow in comparison to the data length (I tested it with 15K rows of data and it could be faster), so some modification is required. The progress bar is also working, but the progress is displayed in steps of 0%, 25%, 50%, and 100%, when I want it to show from 1% to 100%. Please help me to fix this two issues in my vba coding.

Thank you in advance.