Sales Day Tracker.wip.xlsx

Good day Excel Pro's,

I have attached my spread sheet for convenience.

What I am having difficulty with is pulling all company names from the sheets into list formats on the data sheet.

I have company names that occur in cells

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

I will be putting 52 sheets in there which would represent 1 week of the year. Attached is just the first 3 months.

There are 2 lists, 1 which pulls client names that have been called and 1 which would pull through client names that have a "yes" in the converted cell.

Ideally I would prefer to use formulas to achieve this but VBA is an option I would not turn down.

Thanks in advance for you support.