Spreadsheet: 776780d1649918130-automatically-copy-data-into-summary-summary-example-glenn-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Book 1, Sheet A, [NAME]. Actually looks like this
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name |  | Date | Chit |  | Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2021-12-12 00:00:00 | S 015 |  | 2614.75
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  | Name | Shift | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2021-12-18 00:00:00 | M 014 |  | 1899.18
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 1 |  |  |  |  |  |  |  | [NAME] |  | 2022-01-04 00:00:00 | S 016 |  | 1874.23
 |  |  | [NAME] | Here are details that are irrelevant to the
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go
 |  |  | [NAME] | into the summary. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA |  | 2022-01-05 00:00:00 | L 093 |  | 2255.24
 |  | 2021-12-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 14
 |  |  | [NAME]
 |  | 2021-12-18 00:00:00 | [NAME] |  |  |  |  | 1874.23 |  |  |  |  | 25 |  |  |  |  |  |  |  | BBB |  | 2022-02-16 00:00:00 | R 1224 |  | 2167.76
 |  |  | AAA | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | AAA | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC |  | 2022-03-08 00:00:00 | M 015 |  | 2350.48
 |  | 2022-01-05 00:00:00 | AAA | into the summary. |  |  |  | 2555.24 |  |  |  |  | 44
 |  |  | BBB | Here are details that are irrelevant to the
 |  |  | BBB | summary. Only C9, D9, I9 and N9 go |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Book 2, Sheet A, Summaries
 |  |  | BBB | into the summary. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary S will look like this: The newest [NAME] is always added at the top.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doing that manually now, by creating more rows. If that is too troublesome,
 |  | 2022-02-16 00:00:00 | BBB |  |  |  |  | 2167.76 |  |  |  |  | 49 |  |  |  |  |  |  |  | I can start a new sheet, where new entries are added at the bottom.
 |  |  | CCC
 |  | 2022-03-08 00:00:00 | CCC |  |  |  |  | 2350.48 |  |  |  |  | 67 |  |  |  |  |  |  |  | Name | Shift ? | Date | Chit | Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S 017
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2022-01-04 00:00:00 | S 016 | 1874.23
 | I set up a named range - called data - (CTRL-F3 to view - edit) to adjust the range automatically: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2021-12-12 00:00:00 | S 015 | 2614.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary M will look like this:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Shift ? | Date | Chit | Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCC |  | 2022-03-08 00:00:00 | M 015 | 2350.48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2021-12-18 00:00:00 | M 014 | 1899.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | etc. 4 summaries.