I'm working on a very basic spreadsheet for my dispatchers so that they can click a hyperlink in a cell that opens a specified folder on our server. I can manually enter the hyperlink each time but this sheet is live and changes throughout the day which requires me to spend most of the day updating it.

What I want to do is set it up so that when one of the planners enters the PRO number (5 digit) into the cell it automatically sets the hyperlink to the folder on the server drive.

I have attached a picture of what I'm trying to do and please keep in mind I'm an operations manager not a computer programmer.