Dear all

I've got a situation where I have a lot of underlying Excel files linked to a single Excel report. I'd now like to make it easy to navigate in the Excel report by using a combo or list box, and I'd like the content in a worksheet to change depending on what the user chooses from the combo/list box.

There's an area of cells in one of the worksheets in the Excel report which I'd like to change depending on the chosen item in a combo/list box, and there's about 30 equal (though with different content) underlying files for this cell-area. What I need is guidance to is the VBA code that can solve this.

I'm not even sure whether I should use a list or combo box, so I've got a pretty long way ahead of me... Any help will be highly appreciated on this.