Spreadsheet: 544637d1508968913-trying-to-consolidate-a-number-of-sheets-into-1-example-for-excel-forum
Sheet: Sheet1

Name | Job Number | start date | Due date |  |  |  | **Comments** This sheet is the sheet I am hoping to have all the consolidated data from the other sheets displayed. Each day, the data on sheets 2, 3, 4 etc. will change and so will their range(Consistantly be 38 columns long, however the amount of rows down will change each day. Im hoping to be able to update the data in sheets 2, 3 ,4 etc. and have this "master sheet" update with their data automatically.
name | 11115555 | 2017-05-05 00:00:00 | 2017-05-15 00:00:00
name | 11115555 | 2017-05-06 00:00:00 | 2017-05-16 00:00:00
name | 11115555 | 2017-05-07 00:00:00 | 2017-05-17 00:00:00
name | 11115555 | 2017-05-08 00:00:00 | 2017-05-18 00:00:00
name | 11115555 | 2017-05-09 00:00:00 | 2017-05-19 00:00:00
name | 11115555 | 2017-05-10 00:00:00 | 2017-05-20 00:00:00
name | 11115555 | 2017-05-11 00:00:00 | 2017-05-21 00:00:00
name | 11115555 | 2017-05-12 00:00:00 | 2017-05-22 00:00:00
name | 11115555 | 2017-05-13 00:00:00 | 2017-05-23 00:00:00 |  | Data from Sheet 2
name | 11115555 | 2017-05-14 00:00:00 | 2017-05-24 00:00:00
name | 11115555 | 2017-05-15 00:00:00 | 2017-05-25 00:00:00
name | 11115555 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115556 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115557 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115558 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115559 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115560 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115561 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115562 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115563 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115564 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115565 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115566 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115555 | 2017-05-05 00:00:00 | 2017-05-15 00:00:00
name | 11115555 | 2017-05-06 00:00:00 | 2017-05-16 00:00:00
name | 11115555 | 2017-05-07 00:00:00 | 2017-05-17 00:00:00
name | 11115555 | 2017-05-08 00:00:00 | 2017-05-18 00:00:00
name | 11115555 | 2017-05-09 00:00:00 | 2017-05-19 00:00:00
name | 11115555 | 2017-05-10 00:00:00 | 2017-05-20 00:00:00
name | 11115555 | 2017-05-11 00:00:00 | 2017-05-21 00:00:00
name | 11115555 | 2017-05-12 00:00:00 | 2017-05-22 00:00:00
name | 11115555 | 2017-05-13 00:00:00 | 2017-05-23 00:00:00 |  | Data from Sheet 3
name | 11115555 | 2017-05-14 00:00:00 | 2017-05-24 00:00:00
name | 11115555 | 2017-05-15 00:00:00 | 2017-05-25 00:00:00
name | 11115555 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115556 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115557 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115558 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115559 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115560 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115561 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115562 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115563 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115564 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115565 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115566 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115567 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115568 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115569 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115570 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115571 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115572 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115573 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115574 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115575 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115576 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115577 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115578 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115579 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115555 | 2017-05-05 00:00:00 | 2017-05-15 00:00:00
name | 11115555 | 2017-05-06 00:00:00 | 2017-05-16 00:00:00
name | 11115555 | 2017-05-07 00:00:00 | 2017-05-17 00:00:00
name | 11115555 | 2017-05-08 00:00:00 | 2017-05-18 00:00:00
name | 11115555 | 2017-05-09 00:00:00 | 2017-05-19 00:00:00
name | 11115555 | 2017-05-10 00:00:00 | 2017-05-20 00:00:00
name | 11115555 | 2017-05-11 00:00:00 | 2017-05-21 00:00:00
name | 11115555 | 2017-05-12 00:00:00 | 2017-05-22 00:00:00
name | 11115555 | 2017-05-13 00:00:00 | 2017-05-23 00:00:00 |  | Data from Sheet 4
name | 11115555 | 2017-05-14 00:00:00 | 2017-05-24 00:00:00
name | 11115555 | 2017-05-15 00:00:00 | 2017-05-25 00:00:00
name | 11115555 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115556 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115557 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115558 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115559 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115560 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115561 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115562 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115563 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115564 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115565 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115566 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115567 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115568 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115569 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115570 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00
name | 11115571 | 2017-05-16 00:00:00 | 2017-05-26 00:00:00