Hello!

I am trying to make a spreadsheeet that will allow the user to select itself and bring up all of their relative data. I have a business with 9 stores. I want each store to be able to view their loss in total dollars by week, this year vs last year. What I want is a drop down box that, when a store is selected, all of the relative data will autopopulate in the tables. I feel like I need to use a "vlookup" but it appears to be more complex than that. Please help!