Dynamic dependent drop-down list with cascading queries?

Hi,

I am new to my job and are new to using various features in Excel.

A bit of background knowledge is that I have a large spreadsheet with 10 columns, I want to be able to organise this information through various drop down boxes. I.e. by selecting a particular location the options in the next box (say for example, climate) will be reduced down. I need this to happen over 5 different boxes to give a final choice.

The problem is my spreadhseet needs to be robust for change, I need to ensure I have a dynamic range as the user will be increasing the size of this spreadsheet (or decreasing it) once I have gave them the programme.

Therefore I was just wondering if there is any way of creating cascading queries with a dynamic range....and if so can someone please tell me how to do this

Thanks!

Pl upload sample file with the result required.