Hi,
I have a 20 sheets of data relating to differing regions. Each worksheet
holds the same layout and formulas. I want to have one front sheet that
will allow a user to select a region from a combo box and have the chosen
regional data displayed on that sheet. i.e. bypassing the need for a user to
flick through various worksheets.

Would it be correct to use the INDIRECT & MATCH functions for this, if so
can someone point me towards a website giving a good explanation and
example?

Thanks,
Mickey