You could use a asp page for the person to submit the data in to a database
and and use crystal reports on that database in crystal have a parametre field say on your date which is used in the select expert so you can pull out the information you need and just schedule it to produce a excel spreadsheet for you
hope this has gave you so ideas or started to point you in the right direction
Thanks for your reply KansMan, I have an idea as how would that work when you put it in words, but i have not been exposed to any examples like that so if you could point me to an example that would be great.
It is a bit hard to find anything about it,that's all.