Conditionally importing Data from one of several different worksheets based on 1 factor

Hello,

I am currently working on a spreadsheet that records data from 11 different locations, with each location having it's own page within the workbook.
All of the pages are identical in terms of how the data is stored, the only difference is literally the name of each page (i.e. the location).

What I would like is to have a master page that then pulls through the relevant data, dependent on which location I choose from a drop down list on this page. As each individual page is identical in terms of lay-out, one formula will work for each page, with the only obvious exception is the page reference embedded in the formula. I know how to do a standard lookup for various figures, but I can't figure out a formula that would work with 11 different options... Is there any way to accomplish this?

Thanks,
D

I've made a mock up of the situation that I have in the attached sheet below. In the attachment there are only 5 locations, but in reality there are actually 11.

What should happen is when you choose the city from the drop-down list on the master sheet, the relevant data from the appropriate worksheet should then automatically feed through and populate the currently blank table.

I'm anticipating that VBA will provide a solution, but is there any way to accomplish this without VBA?? (I don't know how well the other people that I'm working with will be able to handle VBA, but all options are welcome, please!!)

dummy data.xls

Regards,
D

Hi limbago,
Attached is what I put together quickly. Given that the cells are in the exact same location for all the worksheets, I made use of the ADDRESS function - but hopefully you can see how the indirect function works. If the worksheets were not named exactly as the drop-down list specifies them, you could've used a vlookup.,
Really, once you get used to INDIRECT, how you apply it is only limited by your creativity in applying it.
If that doesn't make sense get in touch.
Thanks,
Lady Marmalade