Spread New Hires to Department/Positions

Greetings Community,

My first day here please be patient until I master the rules!

My challenge:

Large number new candidates hired and need to be set up to their respective positions on attached work sheet. I want to enter data only on first sheet and excel to add their entire row information to their position work sheet. that is if the question in column "O" accept? is "YES" This I know is very simple and silly for you excel gurus! but it means a great deal to me if you let me know what I need to do.

Thank you,