The sheet is going to be used by novice users so it needs to be completely automated. Also, for every appointment there are actually 5 cells of data so it would be rather complex.
I think what I was looking for is excel's built-in data entry feature but instead of populating fields in a row I wanted to populate the matrix.