Data Extraction from Other Sheets Based on the Value from the Dropdown List

Hi Everyone

I'm facing a problem while trying to extract the data from other sheets based on the value from the dropdown list. I'd be really grateful if anyone can guide me how to do it properly.

I've attached the sample workbook, and there's the sheet named "Result" where I wrote the result manually.

Thanks in advance!