Creating 3 lists from data across the workbook

[max8719]

Good Day,

I have a challenge for which I have came to a dead end.

I would like to achieve to generate 3 lists pulled into an "overview" sheet from data across 52 sheets representing weeks.

List 1 would be names of clients called - which would be any non blank cells in the cell references (Client Names):

C5:Q5
C14:Q14
C23:Q23
C32:Q32
C41:Q41
C50:Q50
C59:Q59
C68:Q68

List 2 would be names of clients visited - The client names will pull through if the cells are not blank in the cell references (Visit Date):

C7:Q7
C16:Q16
C25:Q25
C34:Q34
C43:Q43
C52:Q52
C61:Q61
C70:Q70

List 3 would be names of clients converted - The client names will pull through if there is a "yes" value in the cell references (Converted):

C9:Q9
C18:Q18
C27:Q27
C36:Q36
C45:Q45
C54:Q54
C63:Q63
C72:Q72


Thanks in advance for your support.