Automatically populate cells from a drop down list

[Srobin]

Hello,
I wonder if anyone can help. I'm a relative novice at excel and I've been stuck on something for quite some time. I need to take information from several spreadsheets within one workbook. Each spreadsheet has data from a particular digital platform, the title of a digital release, the country it is released in and the retail and wholesale price in that country. I want to be able to create 1 mastersheet where you can enter the title, the country of release and the platform and then this will automatically bring up the pricing information. Is there an easy way to do this?

Any help would be appreciated.
Thanks