copy selected cells to new sheet

good morning all

I have this workbook a friend sent me he found it on his system from past manangers

I would to get it to auto fill the last tab ( Action Plan ) with in info from the other tabs but leave that item if blank

Hope you can help

Regards Scott