Populating Excel sheet from data based in a second sheet

I have read through other posts on this to try and get my head around it, but I'm struggling.    I have a Master sheet (called Master Spreadsheet) that contains data that I want to use to populate ...