Sending data from a cell to a blank table
 

I have created a simple excel sheet that calculates and arranges various
things for a friend in the medical field. He would like me to have a sheet
that calculates totals for a given day. The way it is set up right now, I
have created a template sheet that he opens and then saves as the patient's
last name. I am wondering if there is any way to instruct a certain cell in
the template sheet (and thus in each newly saved copy) to send data to the
next available space in a blank table somewhere. Any help would be very much
appreciated!