I have a workbook with 5 sheets. On sheet one (INSPECTION), I need the text from column G to populate another sheet if a "Y" is in corresponding row. So, if a "Y" is in D9:D308 I need the text from the corresponding cell in column G to populate sheet 3 (Immediate Action) starting with B3. If a "Y" is in E9:E308, I need the text from the corresponding cell in column G to populate sheet 4 (Deferred Maintenance) starting with B3. If a "Y" is in F9:F308, I need the text from the corresponding cell in column G to populate sheet 5 (60 Day) starting with B3. Hope this makes sense. 
