NEED HELP! Conditional formula based on drop down menu, multiple sheets.

[oscarcarl]

Hello,

I am creating a workflow document utilizing one sheet to store all jobs, with proceeding sheets to delegate jobs to staff members based on a drop down selection and populate proceeding sheet(s) with information from the first sheet.

For example,

I will input the job information on the first sheet: Client name, task, assigned to, priority and deadline.
Based on who I select as "assigned to" I want Client, task, priority and deadline to populate one of the proceeding sheets (eg admin, sales, marketing, design, programming)
It has to bump down to a new line each time a new task is entered.

I also want Sheet 1, Priority to update each time it is updated on one of the proceeding sheets. If Joanna is working on a task, and she chooses, "In Progress" from the dropdown menu for 'Status' on her sheet, I want it to update the Sheet 1: Admin Sheet, so a supervisor can look at one sheet and see where we are with each task. I will send the actual doc if necessary. I really need help with this. Thank you,

Sheet 1:Admin

Client	Task	Priority	Assigned to	Deadline	Status	Notes

<tbody>
</tbody>

Sheet 2:Joanna

Task

Start Time

End Time

Total

Status

Priority

<tbody>
</tbody>

Sheet 3: Hidden Drop Down Options Clients Admin Tasks Sales Tasks Marketing Tasks Design & Programming Tasks Priority Assigned to Progress Client ABC Contract Sales Proposal Marketing Proposal Logo High Alexis In Progress Client 123 Invoice Sales Agreement Marketing Strategy Business Card Med Dean On Hold Marketing Estimate Low Mitch Not Started See Notes Summer Waiting for Info 1 Joanna Completed 2 Randy Revision 3 4 5 6 7 8 9 10 <tbody> </tbody>

<tbody>
</tbody>