create automatic reports

Hello,

I would like to know how to come up with automatic reports from a spreadsheet which has colums for names, hours worked, hourly rates and totals. Each time you enter the name for different dates in the month should go directly in the report for each individual. How can I have excel create automatic reports for each of the names with the info on each column?

Will greatly appreciate your input or any feedback.

Thanks