Need to be able to populate data from sheet 2 to sheet 1 based on header name in sheet 2

Hi,

I hope my problem makes sense and can be solved. i have looked through other threads but haven't seen the same issue exactly.

I have attached an example sheet.

In sheet 2 I have a list of data, locations with corresponding figures per month.

On sheet 1 I have a summary page.

What I would like to do is in Sheet 1, A2 I would like to have a drop down list containing all the names from Sheet 2, A2:A100

When I select a name from this drop down list... example; Dublin... I would like all the data from Sheet 2, B2:M2 to populate in Sheet 1, B2:M2

If possible I would like to be able to do this to compare 2 area's also. Example... On A2,Sheet 1 Select Dublin and populate info... On A3, Sheet 1 Select Kerry and populate info and so on

Apologies if this seems an easy solve but I cannot for the life of me figure it out!

Hi Martha,

Try see attached file , hope it helps..

example1.xlsx