We currently use an Excel WebQuery file which lists our business's physical inventory on a line item basis. We need to be able to create (and download) daily warehouse pick lists from a custom template on a separate tab, which pulls in data from the WebQuery file.
Attached is a quick mock up I put together as an example. There may be a few additional fields we need to add to the Pick List template based on our needs.
Typically, we'll have 10-20 pick lists per day, with an average of 18 items per pick list.