I made a typo earlier....

For example, if Dr. John Doe did 7 surgeries this month, i need excel to
sort through the data on the main worksheet and paste the data for only his 7
spreadsheets to a tab that is labeled with his name (so I can see how he did
for this month).

It should say "for only his 7 surgeries"

Sorry....