Using LEFT & FIND inside INDEX & SMALL function

Hi, I am using an INDEX and SMALL formula that is working, but due to the data having 2 different formats to be summarised as 1, I am having to use a seperate column to over come the 2 formats and I am wondering if I can do this inside the INDEX and SMALL formula.

The data is in column B and C. Note that in column C, Joe Bloggs has 2 variations.
data.PNG

In column A, I have a simple LEFT & FIND formula to create a list that is entirely recognised as "JOE"
data formula.PNG


The INDEX and SMALL forumla that is working in column B on the Summary tab is:
=IFERROR(INDEX(Data!$B:$B,SMALL(IF(Data!$A:$A=B$2,ROW(Data!$A:$A)),ROW(1:1)),1),"")

and my attempt to not need the LEFT & FIND formula on the data tab in column D is:
=IFERROR(INDEX(Data!$B:$B,SMALL(IF(LEFT(Data!C:C,FIND(" ",Data!C:C)-1)*1=D$2,ROW(Data!$C:$C)),ROW(1:1)),1),"")

summary.PNG

How can I amend the INDEX and SMALL formula to essentially search for the first name and then use that to drive the INDEX and SMALL list that is created?

I have uploaded the excel file for reference

Any help greatly appreciated