How to create an excel data repository?

[Akshaysehgal]

Hi guys, I have been trying to create a "data repository" for a task list, where the user inputs the tasks for the day on one sheet and it automatically gets fed into a table with the list of dates as rows. The input is something like :

INPUT/=today()	Task	ETA	Status
Resource A	xyz	xyz	Completed
Resource B	xyz	xyz	Pending
Resource C	xyz	xyz	Completed
OUTPUT/Status	Resource A	Resource B	Resource C
13th Nov	Completed	Completed	Completed
14th Nov	Completed	Pending	Completed
15th Nov
16th Nov

<tbody>
</tbody>

The output table can be for keeping a track of tasks/Status. The idea is that the user just has to put in the tasks for the day (and related info) while another sheet automatically keeps a track of all the previously inputted tasks/status. I am quite weak with VBA so I would prefer a solution in excel itself. Can you guys help me with this? - Appreciate any inputs/ideas, Akshay.