Scott,
with due respect, this is a job for a database, not a spreadsheet. If
you are insistent on using a spreadsheet program like Excel then create
a shared workbook and use a form to add data. Load the for from the
Workbook_open event.

OJ