Pulling information from 1 of 3 Workbooks

I am working with 4 Excel Workbooks for this project. I have created a combo box on my first Workbook, where it has a list of cities. Once a city is selected, I am trying to get it to pull information from one of the other 3 workbooks.

My problem is I can't seem to create a formula that will after a city is picked pull from the correct Workbook that has that city name listed in it.

Things I have tried:
- I cannot pull all the data from the other 3 into one Excel Book, the file is too large

-I have tried a series of If statements and Vlookup, I have too many arguments in the list

- I feel like I need to use VBA for this but am new to programming and not sure where to start.

Any and all help is greatly appreciated!

It sounds like you should be using access.