microsoft excel 2010 - Move a cell based on date input across row - Super User

i have multiple people single task have complete on date. need put each person own row , have dates in title of each column. want each person's task day correspond dates in title. manually put them in, tedious when have several people schedule for.

i want able input date on separate sheet , have excel place task on schedule automatically. here's example of want:

how can accomplish this?

note: have no experience vba, , if easy fix it, apologize , appreciate that.

microsoft's page explains how use =vlookup() formula reference cell based on cell , value.

the syntax follows:

vlookup(lookup_value, table_array, col_index_num, [range_lookup]) 

if b1 contains date care , a2 contains employee id, might use following formula:

=vlookup(b$1, indirect($a2&"!a:b"), 2, false) 

each employee need own worksheet name matching contents of cell a2, etc. worksheets formatted column a containing dates , column b containing tasks.