salesforce – Stock Inventory Issues

I’m in need of some help with my google sheets project.

I currently run a small business. And use sheets as a way to manage stock. I want to create QR codes to scan on item that will take me straight to the cell to adjust stock levels. However, when I insert a new row for an item, this changes the location for all QR codes already generated.

Is there a way around this? For example. If I have 3 rows of stock items. If I insert a row between row2 and row3 then row3 becomes Row4. But the QR code generated will still take me to Row3 which would now be incorrect 😫