I barely know Excel - help

I am trying to create a formula/function where: If a particular cell (H*) contains a 'yes' then the value in G* from Sheet * will copy to column A* in a different sheet.   Keep in mind that I am in Excel Kindergarten and use it only when necessary to complete a task. 

Thanks

Susan