vba SelectionChange based on the cell value on the column

Hello community!   I have a spreadsheet that contains multiple data and each line on the raw (item code) have drawings / work instructions that are located on different excel sheets. The work instr...