create a link base on cell value

Good day, i was trying to create a link for every single folder depending on the code indicated on A column. is there any way i can do it easily instead of manually putting the path (located on E column)? the Name (A column) can go up to WRK-1-23 up to WRK-200-23 and it takes a lot of time to do it manually.



Hope anyone could help. thank you.