Spreadsheet: 744762d1629446723-combine-data-from-multiple-tabs-into-one-tab-eh-combine-data-in-one-sheet
Sheet: Master (what I want)

2021-09-01 00:00:00
 |  |  |  |  | Week 1 |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
TEAM MEMBER | ACTIVITY | PRIORITY | CLIENT (IF APPLICABLE) | HOURS SPENT (Estimate) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
Granit | Holiday | N/A | N/A |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
Granit | Training | N/A | N/A |  | 3 | 3 | 5 | 1 | 1 | 3 | 4 | 4 | 4 | 1 | 1 | 2 | 5 | 3 | 5 | 1 | 2 | 2 | 3 | 2 | 1 | 2
Granit | XYZ | LOW | Premier |  | 4 | 3 | 1 | 1 | 4 | 5 | 3 | 5 | 1 | 2 | 5 | 5 | 4 | 2 | 1 | 1 | 3 | 2 | 4 | 4 | 4 | 1
Granit | [NAME] | MEDIUM |  |  | 0 | 1 | 34 | 2 | 4 | 4 | 3 | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 2 | 5 | 2 | 5 | 2 | 1 | 3 | 3
Granit | Dropdown | HIGH |  |  | 1 | 5 | 4 | 2 | 1 | 3 | 4 | 5 | 4 | 2 | 5 | 4 | 4 | 1 | 4 | 1 | 2 | 1 | 5 | 3 | 4 | 3
Granit | Dropdown | LOW |  |  | 4 | 3 | 4 | 4 | 1 | 4 | 1 | 4 | 3 | 5 | 5 | 4 | 1 | 5 | 3 | 3 | 5 | 5 | 5 | 5 | 2 | 4
Granit | Dropdown | MEDIUM |  |  | 1 | 3 | 2 | 4 | 4 | 5 | 5 | 1 | 5 | 1 | 2 | 2 | 4 | 2 | 5 | 1 | 2 | 4 | 5 | 3 | 4 | 3
Granit | Dropdown | HIGH |  |  | 1 | 5 | 4 | 5 | 4 | 1 | 3 | 1 | 4 | 2 | 2 | 1 | 1 | 4 | 1 | 5 | 5 | 4 | 3 | 4 | 5 | 1
Granit | Dropdown | LOW |  |  | 2 | 2 | 2 | 4 | 1 | 2 | 1 | 1 | 4 | 4 | 2 | 5 | 5 | 4 | 1 | 3 | 3 | 4 | 1 | 2 | 4 | 5
Granit | Dropdown | MEDIUM |  |  | 5 | 3 | 5 | 3 | 1 | 3 | 5 | 3 | 2 | 3 | 5 | 2 | 2 | 5 | 1 | 3 | 3 | 2 | 1 | 4 | 2 | 2
Granit | Dropdown | HIGH |  |  | 2 | 5 | 5 | 1 | 2 | 5 | 1 | 5 | 3 | 5 | 3 | 2 | 3 | 1 | 4 | 2 | 3 | 2 | 5 | 3 | 5 | 1
Granit | Dropdown | LOW |  |  | 5 | 4 | 2 | 1 | 3 | 1 | 1 | 4 | 5 | 2 | 4 | 2 | 1 | 4 | 1 | 2 | 3 | 2 | 2 | 1 | 2 | 1
Granit | Dropdown | MEDIUM |  |  | 2 | 3 | 2 | 5 | 2 | 5 | 3 | 2 | 5 | 5 | 5 | 3 | 5 | 2 | 4 | 3 | 4 | 3 | 4 | 5 | 5 | 4
Granit | Dropdown | HIGH |  |  | 4 | 5 | 3 | 3 | 3 | 5 | 5 | 2 | 3 | 4 | 3 | 3 | 4 | 2 | 1 | 4 | 5 | 2 | 2 | 3 | 2 | 5
Granit | Dropdown | LOW |  |  | 2 | 3 | 2 | 4 | 4 | 3 | 2 | 1 | 3 | 4 | 4 | 3 | 3 | 1 | 1 | 4 | 2 | 4 | 2 | 1 | 4 | 1
Granit | Dropdown | MEDIUM |  |  | 2 | 5 | 3 | 3 | 3 | 2 | 5 | 3 | 1 | 2 | 5 | 1 | 4 | 3 | 1 | 3 | 5 | 3 | 2 | 5 | 4 | 3
Granit | Dropdown | HIGH |  |  | 2 | 1 | 3 | 1 | 4 | 2 | 5 | 5 | 4 | 5 | 4 | 2 | 2 | 4 | 5 | 3 | 3 | 4 | 1 | 2 | 5 | 4
Granit | Dropdown | LOW |  |  | 2 | 5 | 1 | 2 | 4 | 1 | 5 | 2 | 4 | 4 | 3 | 3 | 2 | 3 | 3 | 2 | 5 | 2 | 5 | 2 | 4 | 1
Granit | Dropdown | LOW |  |  | 3 | 3 | 3 | 2 | 5 | 1 | 1 | 1 | 3 | 5 | 2 | 3 | 5 | 2 | 5 | 5 | 4 | 5 | 1 | 5 | 1 | 5
Granit | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
Granit | Dropdown | MEDIUM |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
Granit | Dropdown | HIGH |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
Granit | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
Granit | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
Granit | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
[NAME] | Holiday | N/A | N/A |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
[NAME] | Training | N/A | N/A |  | 3 | 3 | 5 | 1 | 1 | 3 | 4 | 4 | 4 | 1 | 1 | 2 | 5 | 3 | 5 | 1 | 2 | 2 | 3 | 2 | 1 | 2
[NAME] | XYZ | LOW | Premier |  | 4 | 3 | 1 | 1 | 4 | 5 | 3 | 5 | 1 | 2 | 5 | 5 | 4 | 2 | 1 | 1 | 3 | 2 | 4 | 4 | 4 | 1
[NAME] | [NAME] | MEDIUM |  |  | 0 | 1 | 34 | 2 | 4 | 4 | 3 | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 2 | 5 | 2 | 5 | 2 | 1 | 3 | 3
[NAME] | Dropdown | HIGH |  |  | 1 | 5 | 4 | 2 | 1 | 3 | 4 | 5 | 4 | 2 | 5 | 4 | 4 | 1 | 4 | 1 | 2 | 1 | 5 | 3 | 4 | 3
[NAME] | Dropdown | LOW |  |  | 4 | 3 | 4 | 4 | 1 | 4 | 1 | 4 | 3 | 5 | 5 | 4 | 1 | 5 | 3 | 3 | 5 | 5 | 5 | 5 | 2 | 4
[NAME] | Dropdown | MEDIUM |  |  | 1 | 3 | 2 | 4 | 4 | 5 | 5 | 1 | 5 | 1 | 2 | 2 | 4 | 2 | 5 | 1 | 2 | 4 | 5 | 3 | 4 | 3
[NAME] | Dropdown | HIGH |  |  | 1 | 5 | 4 | 5 | 4 | 1 | 3 | 1 | 4 | 2 | 2 | 1 | 1 | 4 | 1 | 5 | 5 | 4 | 3 | 4 | 5 | 1
[NAME] | Dropdown | LOW |  |  | 2 | 2 | 2 | 4 | 1 | 2 | 1 | 1 | 4 | 4 | 2 | 5 | 5 | 4 | 1 | 3 | 3 | 4 | 1 | 2 | 4 | 5
[NAME] | Dropdown | MEDIUM |  |  | 5 | 3 | 5 | 3 | 1 | 3 | 5 | 3 | 2 | 3 | 5 | 2 | 2 | 5 | 1 | 3 | 3 | 2 | 1 | 4 | 2 | 2
[NAME] | Dropdown | HIGH |  |  | 2 | 5 | 5 | 1 | 2 | 5 | 1 | 5 | 3 | 5 | 3 | 2 | 3 | 1 | 4 | 2 | 3 | 2 | 5 | 3 | 5 | 1
[NAME] | Dropdown | LOW |  |  | 5 | 4 | 2 | 1 | 3 | 1 | 1 | 4 | 5 | 2 | 4 | 2 | 1 | 4 | 1 | 2 | 3 | 2 | 2 | 1 | 2 | 1
[NAME] | Dropdown | MEDIUM |  |  | 2 | 3 | 2 | 5 | 2 | 5 | 3 | 2 | 5 | 5 | 5 | 3 | 5 | 2 | 4 | 3 | 4 | 3 | 4 | 5 | 5 | 4
[NAME] | Dropdown | HIGH |  |  | 4 | 5 | 3 | 3 | 3 | 5 | 5 | 2 | 3 | 4 | 3 | 3 | 4 | 2 | 1 | 4 | 5 | 2 | 2 | 3 | 2 | 5
[NAME] | Dropdown | LOW |  |  | 2 | 3 | 2 | 4 | 4 | 3 | 2 | 1 | 3 | 4 | 4 | 3 | 3 | 1 | 1 | 4 | 2 | 4 | 2 | 1 | 4 | 1
[NAME] | Dropdown | MEDIUM |  |  | 2 | 5 | 3 | 3 | 3 | 2 | 5 | 3 | 1 | 2 | 5 | 1 | 4 | 3 | 1 | 3 | 5 | 3 | 2 | 5 | 4 | 3
[NAME] | Dropdown | HIGH |  |  | 2 | 1 | 3 | 1 | 4 | 2 | 5 | 5 | 4 | 5 | 4 | 2 | 2 | 4 | 5 | 3 | 3 | 4 | 1 | 2 | 5 | 4
[NAME] | Dropdown | LOW |  |  | 2 | 5 | 1 | 2 | 4 | 1 | 5 | 2 | 4 | 4 | 3 | 3 | 2 | 3 | 3 | 2 | 5 | 2 | 5 | 2 | 4 | 1
[NAME] | Dropdown | LOW |  |  | 3 | 3 | 3 | 2 | 5 | 1 | 1 | 1 | 3 | 5 | 2 | 3 | 5 | 2 | 5 | 5 | 4 | 5 | 1 | 5 | 1 | 5
[NAME] | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
[NAME] | Dropdown | MEDIUM |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
[NAME] | Dropdown | HIGH |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
[NAME] | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
[NAME] | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5
[NAME] | Dropdown | LOW |  |  | 4 | 4 | 3 | 2 | 5 | 4 | 3 | 5 | 4 | 5 | 2 | 5 | 4 | 5 | 4 | 2 | 5 | 5 | 4 | 3 | 3 | 5