Not sure if this is a common thing here, but I've started a basic spreadsheet in Sheets to keep track of my companies inventory. I've managed to use 2d barcodes and create items numbers and print labels for bins.

I have a "Master" sheet with all of the items, costs, bin locations and item numbers, lets call it sheet A. I have a "Reorder" sheet in which I scan all items which are low and the item number is entered into this sheet giving me a list of things needed to reorder. I need Sheet B to reference data from Sheet A depending on which item is scanned.

Willing to pay FG for help

So, when you go and scan everything it auto populates into Sheet B as just a barcode, and you want it to tell you what those items are using the data from Sheet A?

If it's all just numbers then =vlookup(Scanned barcode,SHEET A TABLE, Column of the name of item)

If you can't determine how to do this via captainchopsticks07 answer LMK, might also suggest if there's a common thresh hold for reorder of items add another column, "MinAmt" or something, on the Reorder sheet, have it iterate through all the rows. IF "MinAmt" < "Current Count" flag it for reorder. Remove the step of having to scan the barcode for reorder on some more common items.