This spreadsheet queries the pick and pull inventory in Arlington, and returns a list of all Ford vehicles there. Need to add in Lincolns, and possibly create different versions for other store locations?
Select the Location in the drop down menu in Cell B1, then hit the "Create Inventory List" button.
Give the macro a little time to do its thing.... it has to go back to the pick and pull site for each model in the list, so it takes a minute or so.
Still, this is much easier than how it had to be done before... and ALL Ford and Lincoln vehicles can be seen.