Spreadsheet: 739811d1625970391-pulling-data-from-multiple-sheets-as-summary-power-query-to-combine-tables-kyber-
Sheet: Query1

ID | Client | Date of Meeting | Units | Meeting Type | Duration | Entered | Counselor | Name
91966 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
88341 | Amber Riley | Over the Phone |  |  | 30 mins |  | [NAME] | Table1
33848 | [NAME] | In Person |  |  | 45 mins |  | [NAME] | Table1
23739 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
43135 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
25826 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
25339 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
36788 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
17279 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
50337 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
66334 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
62503 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
87608 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
94616 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
13337 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon | Table1
33899 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
38877 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
54773 | [NAME] | In Person |  |  | 30 mins |  | [NAME] | Table1
80147 | Sacha Baron [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table1
91024 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
49371 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
31930 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
95631 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
69745 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
89418 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
78101 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table1
25826 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table1
97961 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
64035 | [NAME] | In Person |  |  | 30 mins |  | [NAME] | Table2
94388 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table2
31467 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
25339 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
36788 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
17279 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
50337 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
66334 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
62503 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
87608 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
64761 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
99567 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
80934 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
91966 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon | Table2
88341 | Amber Riley | In Person |  |  | 60 mins |  | [NAME] | Table2
33848 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
23739 | [NAME] | In Person |  |  | 30 mins |  | [NAME] | Table2
43135 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table2
25826 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
80559 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
47064 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
84667 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
71450 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
86623 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
32805 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
64061 | Mitch Albom | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
25334 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
33059 | Neve Campbell | Over the Phone |  |  | 30 mins |  | [NAME] | Table2
29584 | [NAME] | In Person |  |  | 45 mins |  | [NAME] | Table2
65246 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
47991 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
20114 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon | Table2
89474 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table2
94616 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table2
33899 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
38877 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME] | Table3
54773 | [NAME] | In Person |  |  | 45 mins |  | [NAME] | Table3
80147 | Sacha Baron [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
91024 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
49371 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
31930 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
93600 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
31883 | Smothers Brothers[B] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
53724 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
51599 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
95631 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
69745 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
89418 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
78101 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon | Table3
91966 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
88341 | Amber Riley | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
33848 | [NAME] | In Person |  |  | 30 mins |  | [NAME] | Table3
23739 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table3
43135 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
25826 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
80559 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
47064 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
84667 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
20382 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
50915 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
68065 | Cooper Manning | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
67507 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
33733 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME] | Table3
39903 | [NAME] | In Person |  |  | 45 mins |  | [NAME] | Table3
36003 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
99670 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
25465 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table3
53132 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table3
91966 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
88341 | Amber Riley | In Person |  |  | 30 mins |  | [NAME] | Table4
33848 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table4
23739 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
43135 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
25826 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
80559 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
47064 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
84667 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
20382 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
50915 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
68065 | Cooper Manning | In Person |  |  | 60 mins |  | [NAME] | Table4
67507 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
33733 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
39903 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon | Table4
36003 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
99670 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
25465 | [NAME] | In Person |  |  | 30 mins |  | [NAME] | Table4
53132 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table4
28902 | Eddie Izzard | In Person |  |  | 60 mins |  | [NAME] | Table4
26732 | Eli Manning | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
23030 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
75022 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
97961 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
64035 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
94388 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
31467 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
25339 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
36788 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME] | Table4
17279 | [NAME] | In Person |  |  | 45 mins |  | [NAME] | Table4
50337 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
66334 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
62503 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon | Table4
87608 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
64761 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
99567 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
80934 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME] | Table4
65131 | [NAME] | In Person |  |  | 45 mins |  | [NAME] | Table4
24935 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
55156 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
40011 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
96790 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
71048 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
52278 | [NAME] | In Person |  |  | 30 mins |  | [NAME] | Table4
46668 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME] | Table4
34486 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
84325 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
28777 | [NAME] | In Person |  |  | 60 mins |  | [NAME] | Table4
72276 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME] | Table4
 |  |  |  |  |  |  |  | [NAME]