DISTINCT COUNT - From Another Table as String

Hi All, I have been at this for hours and looking thorugh other post's nothing quite works.   Hours_Spend_Data - is my data table which contains all weeks worked, hours, charges by site / colleagu...