Fetching data from multiple sheets based on drop-down list

Hi all!

I am sure that there are many ways to do this but what would be the easiest?

I want to have a data storage from which I get my data. There will be many sheets containing data (different market areas). On these sheets there will be many items, as seen in the attachment, that all have a value that will be brought back to the main sheet based on the selection of the drop-down menu. All the sheets have their own values for X, Y, Z, D etc.

Please see the attachment to understand the situation. Is this possible?

The desired output would be on another sheet / or on the main sheet bringing values based on the selections. Please note that in reality there will be much more items on the sheets as well as more sheets containing product groups.

Thank you very much in advance!