Autopopulate multiple data sheets

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!

Hi there,

I was sitting with a similar problem recently. What you can do is have a standard workbook that on different sheets, it references to the various store workbooks.

From the complexity, It sounds like you will need to run a Macro. unfortunately, I'm not that good at Macros.