Autopopulate from (if brochure x then corresponding ID x )

Hello 

I am creating a template for ordering brochures and gimmicks.

I have a list of the names of the brochures, linked to different products, and their respective id number in a sheet. That is 3 separate columns.

In a different sheet I am making my order by using dropdown function from the above list using the brochure name (as this is easy to identify). 

I now want to create a formula so when I choose the name of the brochure in one cell (from the dropdown), the corresponding id is chosen in the adjacent cell (from the list I have in a separate sheet). 

Ideally I would have another first determinant of the country as 4 countries have different brochures and id numbers but I would like to use the same ordering sheet only changing the name of the country....and then having 4 sheets, one for each country that includes the brochure names and IDs. These lists would then be regularly updated as new brochures and gimmicks are made available.

Thank you