The sequence is correct. But I sort from product location not item number. I can have multiple same items in the warehouse. I can't have multiple locations. So your line number 4 in your sequence should read, Find the row on "OUTBOUND" that contains the Warehouse location. And I use locations like A3, B3, C3, A5, etc.
I only have one PICK TICKET worksheet
I fill the same PICK TICKET out every time. What I do is I type the item number and the quantity. I use a vlookup and index to lookup the item description and the next warehouse location to pull product from. I then process the order and I have that codedin a macro to clear the PICK TICKET and store the data in variables. (warehouse location only as of now) Then it filters the OUTBOUND worksheet by location from the PICK TICKET data and hides everything else. Then I have to manually type in the quantity to deduct. This is where I'm stuck. I don't care if it does not filter as long as it automatically deducts the right product from the right location from the OUTBOUND worksheet.
I always start the pick ticket at A2 for item number, C2 for qty, and D2 for location. I just work my way down if i have more then one product.
AJ does not have formulas buy AK does. I can always move them farther right if i need to. Next could hit that cell but i could just move all the data thats in AK way to the right of anything.
Hope i answered everything.