Auto populate packing list from separate worksheet

I'm trying to auto populate full rows of information when I select a certain location. On my main packing list, I have locations set up. If I select a city, it pulls the data from sheet 2 and plugs in the city's address, contact and phone number. I want it to also populate the packing information. This will include information from sheet 3. It will need to pull each person and their items they have ordered, over to the packing list. I have used the vlookup function and this will pull the first row of information but I can't figure out how to make it to pull any more. For instance, my first row equation looks like this: =VLOOKUP(H7,Locations2!A1:F7,2,TRUE). This will pull the name of the first person that matches the city on my packing list. But I can't get it to find all the people for this city. I have sample data in this worksheet that I uploaded.

Ok I believe I have added what you requested. If not, then could you please explain what you are needing in a different way. I wasn't sure what to put in the additional column on the Location sheet but I did add unique numbers to the Locations2 sheet.

Ok I hope I have updated as needed. I have changed a few things to hopefully make it easier to keep separate. I want 3 different things to change when I select the location from the highlighted drop down list.Attachment 561733 I have changed the tab from Location2 to Employees because thats what they are. These individual employees will place orders, and they will be shipped to certain locations in groups. I changed the tab from Sales Invoice to packing list (didn't realize it wasn't listed that way already).I added an ID column to the packing list since I believe AliGW said it will follow the customer where ever the record goes. Sorry for any confusion. I'm OK with excel but I'm just now really learning about functions. Before a few days ago I just understood how to get averages. I have added additional people to employees that have the same locations. And I intentionally left 2 people without any orders. When our large group places an order, they tend to send a list of about 500 people, but not all get things so there are times when several people have nothing next to their names. I hope this new worksheet helps.

Thank you for the response and help. For the most part, this is what I want. The only small issue is that it populates all the people who are listed for a city even if they haven't placed an order. Is there a way to filter out the ones who work at a location but didn't actually order anything? There are times when I get a list of 500 but only 100 ordered something so Id have 400 people not needing to be on the list.

Ah Yes! This fixed it. Perfect. Thanks so much for all your help. Now I'm just trying to make myself understand what each part of the function does so that I can use this style in the future. I appreciate your help very much! The first new formula is what fixed it. Each person always orders a shirt. The other items are optional.