Spreadsheet: 823643d1680072071-using-let-to-collate-data-and-sorting-data-based-off-date-column-excel-help-8
Sheet: Sheet1

 | Name | Position | State | Clinic | Hiring Manger | Entity | Employment Type | Commencement Date |  | 1 Month Check In | 3 Month Check In | 5 Month Check In | 6 Month Review |  | Next Update | 1 Month Check In | 3 Month Check In | 5 Month Check In | 6 Month Review |  |  |  |  |  | yes
 |  | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-07-25 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no |  |  |  |  |  | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-08-15 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | 2022-08-29 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-09-05 00:00:00 |  |  |  |  |  |  |  | yes | yes | yes | yes
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-09-05 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | 2022-09-05 00:00:00 |  |  |  |  |  |  |  | yes | yes | no | no
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | 2022-09-12 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | 2022-09-14 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | 2022-09-19 00:00:00 |  |  |  |  |  |  |  | yes | yes | no | no
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Fixed Casual | 2022-09-19 00:00:00 |  |  |  |  |  |  |  | yes | yes | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Fixed Casual | 2022-09-19 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Casual | 2022-10-05 00:00:00 |  |  |  |  |  |  |  | yes | yes | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-10-06 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-10 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-11 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no | Also once data is in the 1 sheet can I filter on date and then if the cells move around will the data in Q:T also move with it or no because one is collated from another spreadsheet and one is in the current sheet?
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PPT | 2022-10-14 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | Alayna Woods | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-17 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-24 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | Essence Esparza | NER | WA | ERD | [NAME] | 1 | PPT | 2022-10-31 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-10-31 00:00:00 |  |  |  |  |  |  |  | yes | no | no | no
 | Mathias Friedman | MR | SA | PRA | [NAME] | 1 | Fixed Casual | - |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | - |  |  |  |  |  |  |  | yes | no | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | - |  |  |  |  |  |  |  | yes | yes | no | no
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | - |  |  |  |  |  |  |  | yes | yes | no | no
 | ^^^^^
 | [NAME] to sort data on [NAME] but needs to be only the values with TRUE and sorted by commencment date (some dates have "-")