Increment the hyperlink

Hello,

I am looking to increment hyperlinks with a variable to open folders.
I have column A with variables 1 to 5000.
I have column B with a "PDF" button that opens the corresponding file 1 to 5000.
I have created column C with a "DOSS" button to open a Windows folder window for the corresponding 1 to 5000 storage location, instead of the corresponding storage.
I have linked the path for example:
\\srvfichiers\Production_commun\pdf\1125
it works very well but it is impossible to increment the folder number
and replace "1125" with the variable from column A, e.g. "1125" would become $a$1125
\\srvfichiers\Production_commun\pdf\$a$1125

but it does not work.

so at this point the only solution is to rename the links one by one
a titan’s work.

(thanks, by the way, for a hyperlink to a file the incrementing works, but not for a link to a folder)

Does anyone have a trick?

Thanks in advance