Dropdown list based workbook.

Good day everyone,

Obviously I'm new to the forum, and I'm not sure how to narrow what I'm looking for into a few words, otherwise I would search it out. So here it is:

I work for a trucking company, and we deliver to a number of locations. I'm trying to make a sheet that's easy for others to use so they can acquire location information.

The format I'm trying to get is a drop down list that shows all the location codes. This I can do. What I can't figure out is how to format the cells below the drop down list to change as different selections are made from the drop down list.

So I'd like to have the data for each location stored on another sheet in the workbook that the main sheet can pull from and list below.

The top of the main sheet will say Store Location: (drop down list with all the location codes)

Then below, I'll have different parameters for the various data pertaining to the selected location, i.e. phone number, address, driving directions.

The main goal is for my dispatchers to open the workbook, select a location code from the drop down list, then all the data for that specific selection appear below, then they will be able to print the sheet with only the information of the selection from the drop down list.

Any guidance is appreciated.