Does anyone know a way to create an interactive/revolving formula that would
automatically refresh daily?

Here's what I'm trying to do:

I have a list of Doctors, I need to track their daily number of biopsies and
patients seen. I need to create a simple daily summary for my director that
will
report the pertinent numbers but refresh automatically the next day when new
numbers are entered in another worksheet (within the same workbook). Make
sense?

I appreciate any and all help.