Need help creating a Auto populate worksheets based cells in another worksheet text based

Hello,

I would like to say thank you in advance. Here is what i am wanting to do:
I am a total newb at formulas and functions, i am trying to create a workbook that based on the worksheet Activities report it will auto populate the other work sheets (PCSD, Store 1,, PRP LOG) based on the drop downs of column G to populate the work sheets PCSD, Store 1 and PRP LOG and copy/return the text info of the entire row.


I plan on locking done all sheets except the "Activities Report" worksheet to prevent the formulas from being messed up, if possible i would also like to auto populate the worksheets Team 1 and Team 2 based off the drop downs in column B on the activities report.

I have asked around some coworkers and being told that excel would not perform this and i am asking to much of the program, i don't believe them

My apolgies,

Here is a sample.

Thank you,

Currently all these work sheets reside in different work books and have to be manually entered into the different work sheets (yup gotta love redundancy), of course based on what activity you are doing depends on what sheet you are duplicating. The idea is to reduce the copy and paste.

I have gotten this formula to barley work =IF('ACTIVITIES REPORT'!$G9="PRP",'ACTIVITIES REPORT'!G9," ") I am unable to add the second word i want it to look for also getting blank rows when it does not find the word in the cell.

Thank you,