Autofill cells with information contained in other sheet

Hi there !

I'm trying to solve a problem which I guess some of you have already seen many times.

I have a workbook with two sheets. The first one, let's call it the Main sheet, will be used to keep track of the touring artists of a record label. The second sheet contains a list of show venues with their respective contact info. Here's what the two sheets look like :

Main sheet
mainsheet.jpg

List of contacts
listofcontacts.jpg

What I would like is row D of the Main sheet to autofill, according to the contact information contained in row B of the List of contacts, when I enter a venue name in row C of the Main Sheet.

Does that make any sense ?

Thanks a lot and I hope to hear back from you !