Scheduling Help

[MastahFez]

Hello Excel Forum
im new to this community. i've been looking for an active community that i can join to give and receive help.

i have a weird Dilemma i would like to present to you guys.

i have a table that is organized by day and person.
and each cell has a name of a job that is doing that job for that day

i would like to create a new worksheet with a similar table
but instead have it organized by day and job
and each cell lists the name for that person on that day.
i would like for the cells to contain a formula to search the first worksheet and find
the name of the person, and then list what they are doing for that day. and display it
in the appropriate cell for that specific day.

a formula would be preferred, over a VB script. but either or is fine.

sorry if its confusing, heres a pic if it helps.