Spreadsheet: 471484d1469031997-show-a-link-to-the-last-5-rows-of-a-table-from-a-different-spreadsheet-excelhelp-nickscott
Sheet: Sheet1

 | Current Table: |  |  |  |  |  |  |  |  | Would like to see this on separate worksheet, with only the last 5 rows showing as they update:
 | Recorded? | Order # | Date | Order Type | Customer | Product Name | Quantity | Unit Price |  | Recorded? | Order # | Date | Order Type | Customer | Product Name | Quantity | Unit Price
 | X | 1 | 2016-05-27 00:00:00 | Sale | Customer 1 | Product 1 | 6 | 50 |  | X | 6 | 2016-06-24 00:00:00 | Sale | Customer 6 | Product 1 | 4 | 50
 | X | 2 | 2016-06-01 00:00:00 | Sale | Customer 2 | Product 1 | 12 | 50 |  |  | 7 | 2016-06-28 00:00:00 | Sale | Customer 7 | Product 1 | 6 | 50
 | X | 3 | 2016-06-15 00:00:00 | Sale | Customer 3 | Product 1 | 3 | 50 |  |  | 8 | 2016-06-29 00:00:00 | Sale | Customer 8 | Product 1 | 3 | 50
 | X | 4 | 2016-06-23 00:00:00 | Sale | Customer 4 | Product 1 | 4 | 50 |  |  | 9 | 2016-06-29 00:00:00 | Sale | Customer 9 | Product 1 | 10 | 50
 | X | 5 | 2016-06-23 00:00:00 | Sale | Customer 5 | Product 1 | 3 | 50 |  |  | 10 | 2016-07-01 00:00:00 | Sale | Customer 10 | Product 1 | 7 | 50
 | X | 6 | 2016-06-24 00:00:00 | Sale | Customer 6 | Product 1 | 4 | 50
 |  | 7 | 2016-06-28 00:00:00 | Sale | Customer 7 | Product 1 | 6 | 50
 |  | 8 | 2016-06-29 00:00:00 | Sale | Customer 8 | Product 1 | 3 | 50
 |  | 9 | 2016-06-29 00:00:00 | Sale | Customer 9 | Product 1 | 10 | 50
 |  | 10 | 2016-07-01 00:00:00 | Sale | Customer 10 | Product 1 | 7 | 50
 | Updated Current Table: |  |  |  |  |  |  |  |  | Updated Example:
 | Recorded? | Order # | Date | Order Type | Customer | Product Name | Quantity | Unit Price |  | Recorded? | Order # | Date | Order Type | Customer | Product Name | Quantity | Unit Price
 | X | 1 | 2016-05-27 00:00:00 | Sale | Customer 1 | Product 1 | 6 | 50 |  | X | 10 | 2016-07-01 00:00:00 | Sale | Customer 10 | Product 1 | 7 | 50
 | X | 2 | 2016-06-01 00:00:00 | Sale | Customer 2 | Product 1 | 12 | 50 |  | X | 11 | 2016-07-02 00:00:00 | Sale | Customer 11 | Product 1 | 15 | 50
 | X | 3 | 2016-06-15 00:00:00 | Sale | Customer 3 | Product 1 | 3 | 50 |  |  | 12 | 2016-07-03 00:00:00 | Sale | Customer 12 | Product 1 | 14 | 50
 | X | 4 | 2016-06-23 00:00:00 | Sale | Customer 4 | Product 1 | 4 | 50 |  |  | 13 | 2016-07-04 00:00:00 | Sale | Customer 13 | Product 1 | 17 | 50
 | X | 5 | 2016-06-23 00:00:00 | Sale | Customer 5 | Product 1 | 3 | 50 |  |  | 14 | 2016-07-05 00:00:00 | Sale | Customer 14 | Product 1 | 10 | 50
 | X | 6 | 2016-06-24 00:00:00 | Sale | Customer 6 | Product 1 | 4 | 50
 | X | 7 | 2016-06-28 00:00:00 | Sale | Customer 7 | Product 1 | 6 | 50
 | X | 8 | 2016-06-29 00:00:00 | Sale | Customer 8 | Product 1 | 3 | 50
 | X | 9 | 2016-06-29 00:00:00 | Sale | Customer 9 | Product 1 | 10 | 50
 | X | 10 | 2016-07-01 00:00:00 | Sale | Customer 10 | Product 1 | 7 | 50
 | X | 11 | 2016-07-02 00:00:00 | Sale | Customer 11 | Product 1 | 15 | 50
 |  | 12 | 2016-07-03 00:00:00 | Sale | Customer 12 | Product 1 | 14 | 50
 |  | 13 | 2016-07-04 00:00:00 | Sale | Customer 13 | Product 1 | 17 | 50
 |  | 14 | 2016-07-05 00:00:00 | Sale | Customer 14 | Product 1 | 10 | 50