Match multiple criteria from Different Worksheets and return a Value

Hi, like to seek expertise on excel formulas. Looking to match multiple criteria from 2 worksheets and return a value. 1st picture below is from 1st worksheet (Sheet 1). 2nd picture below is from ...