Send data from a cell to a table
 

I have created a template excel sheet that I want to use to keep track of
patients for a friend in the medical field. The friend will open the sheet
and save it as the patient's last name. My problem is that he wants a
billing sheet each day. I think that the solution is to have a cell in the
template sheet that submits data to the next available cell in a table in a
"master" excel sheet ... a sheet that keeps a running total of all entries.
If such a cell were to exist in the template file, it should be copied to all
new patient files. I'm not sure if this makes sense, or if there is a
solution, but I really would appreciate anyone's input ... even if it's to
tell me that I can't be helped! Thanks!
B Harmon