Depending dropbox

Hi

I need to make a Dropbox who populate values depending other Dropbox. For example at the example file I have two sheets, one for the values (Hoja2) and the other for the data (Hoja1). I want to limit the input data to the value list:

- At column Country I define a dinamic range to populate a Dropbox with all the data at the column A at the value list. This I have

- At column City I need that depending on the value I select at column Country shows at one Dropbox all the values at the row of this country I have at values sheets. This values can change, adding or remove values. Is there any posibility to do this with formula and without using range name? I'm think on Offset or Vlook formula but I can't figure out how to use.

At the example If I select EEUU at the column City I nedd it apears at the combo in City column all the values I may have at the row 3 (excluding column A), and set it dinamically (I can delete or add values at the row).

Thanks in advance for any help