Need help creating project management spreadsheet. Drop downs, sheets, populate cells

I am trying to create a spreadsheet to assign work to individuals via a drop down menu selection on another sheet in the same workbook.

For Example:
On the Sales tab (which would be the project management sheet for the sales team) I enter the client information as it comes in.

ABC Company, needs to be invoiced (Sales Task) the Priority is High and it is Assigned To Randy. The Deadline is set, and the status is set, all on this sheet.

When I choose to "Assign to" someone, for instance "Randy" from the drop down menu, I want Randy's tab to populate with information from this page.

I also want it to keep the newest tasks on top, bumping down the previous.

AND It would be great if "Status" when selected on Randy's page could update the "Sales" page.

Am I asking too much here?



I would greatly appreciate any help!

Thanks,
OC

Project Master1.xlsxProject Master1.xlsx