Summarizing report info

[Scribe]

Plz Help - I've set up a large worksheet for daily data
entry and at the end of the month I need a breakdown by
salesmen. I'm looking for advice on setting up a report to
help with this summary. I looked into a pivot report, but
it appears as though you first must have data entered in
the cells (this is a new file, no info has yet been
entered). Are there any other methods of accomplishing
this beforehand or must I wait until data is entered?

Thanks.