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 :[TABLE="width: 500"]
<tbody>[TR]
[TD]INPUT/=today()
[/TD]
[TD]Task
[/TD]
[TD]ETA
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]Resource A
[/TD]
[TD]xyz
[/TD]
[TD]xyz
[/TD]
[TD]Completed
[/TD]
[/TR]
[TR]
[TD]Resource B
[/TD]
[TD]xyz
[/TD]
[TD]xyz
[/TD]
[TD]Pending
[/TD]
[/TR]
[TR]
[TD]Resource C
[/TD]
[TD]xyz
[/TD]
[TD]xyz
[/TD]
[TD]Completed
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OUTPUT/Status
[/TD]
[TD]Resource A
[/TD]
[TD]Resource B
[/TD]
[TD]Resource C
[/TD]
[/TR]
[TR]
[TD]13th Nov
[/TD]
[TD]Completed
[/TD]
[TD]Completed
[/TD]
[TD]Completed
[/TD]
[/TR]
[TR]
[TD]14th Nov
[/TD]
[TD]Completed
[/TD]
[TD]Pending
[/TD]
[TD]Completed
[/TD]
[/TR]
[TR]
[TD]15th Nov
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16th Nov
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.