On the Appointments tab, log each booking: the date, time, patient name and phone, the clinician from a dropdown, the reason, and a status (Booked, Seen, Missed or Cancelled). The Today tab reads it all back for any day you choose, in time order, so the front desk has a clean running list. Doctor Schedule counts how many appointments each clinician has that day, split by status, and Missed lists every appointment marked Missed so you can call those patients to reschedule.
Yellow cells are the only ones you type in; every other cell is a locked formula, so the counts cannot break. Because the book holds patient names and phone numbers, keep it on a device only your staff can reach, and in Google Sheets share it with named people, never a public link. Opens in Excel, WPS or Google Sheets, so you can keep it at the desk or on your phone.