Using Multiable sheets for Invertry Control

I am using multi able sheets for inventory control,, right or wrong  ,,it working ok.

each sheet has a cell set aside for the part number , order number etc.

i can search for order number through ctrl f  or find all , it displays a list of all sheets where that order number appears, and from there eg, select the first on the list  , i get taken to the sheet ,if it is the wrong item , in then have to the next line in the list of find all until i find the right part number .

I can make a query that lists all the sheets that have that order number in the sheet cell, including the part number found relating to that order.

I was trying find a way to now ,using the query list , to select a part number , for that order query  and jump back to the sheet where that part number came from so i can edit ..

hoping this is explained right

Cheers

Bill