Creating Lists from data across the workbook

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

If it helps my workbook is attached.
Tracker.wip.xlsm

Thanks in advance for your support

Here's something. I added a page called maps. This is where I tell the program what rows to look at for client names. Some of the ones you provided are dates and whether a customer has been converted.

Hi Dflak,

I really like the concept of the table generation however on sheet 29.12.16 There is an entry that hasn't pulled through, and I am not sure why.

Please advise.

Many Thanks

Hi xladept,

Thanks for your help. This works. How do I combine both codes? I have tried and getting an ambiguous name error.

Thanks for your support.