|I suggest you try this code in a backup copy of your workbook since macros can not be undone.|
This code will create a list of the surgeon's names in a new sheet ("MD List")and then create a sheet for each surgeon.
It will then copy each row that contains that name in the Master sheet to the specific sheet for that surgeon.
Since I can't see your spreadsheet from where I'm sitting, I had to make some assumptions.
On your Master sheet, I am assuming that you have column labels in Row 1 and that your data starts in Row 2.
I am assuming that you want the same column labels on each individual sheet.
You said that you didn't need to copy the entire row, but you didn't say what you really needed, so the code copies the entire row. This can be modified.
Let me know what you think
Dim numShts, numItems, srcMD, mdSht, nxtRow As Integer
Dim mdName As String
'Add a new worksheet for filtered list of MD Names
ActiveSheet.Name = "MD List"
'Create a list of unique MD Names
Sheets("Master").Columns("C:C").AdvancedFilter Action:=xlFilterCopy, _
'Count number of MD names so we know how many sheets to create
numShts = WorksheetFunction.CountA(Sheets("MD List").Columns("A"))
'Create new sheets, named for each MD, add Column lables
For mdSht = 2 To numShts
ActiveSheet.Name = Sheets("MD List").Range("A" & mdSht)
'Count number of lines to be copied
numItems = WorksheetFunction.CountA(Sheets("Master").Columns("C"))
'Copy each row to specific MD's sheet
For srcMD = 2 To numItems
mdName = .Range("C" & srcMD)
nxtRow = WorksheetFunction.CountA(Sheets(mdName).Columns("A")) + 1
.Range("C" & srcMD).EntireRow.Copy _
Destination:=Sheets(mdName).Range("A" & nxtRow)
Posting Tip: Before posting Data or VBA Code, read this How-To.