Spreadsheet: 164133d1340655427-excel-2007-need-help-pulling-info-from-several-tabs-into-one-final-tab-orders
Sheet: WE 6-23-12 

 |  |  |  |  |  | WEEK ENDING: |  |  |  | 2012-06-23 00:00:00 |  | Over Pack |  |  | Full Case
Store # | Store | Date | Pgs. | Order# | Puller | Total Time | QA | Total Time | Stacker | Total time | Total Time | Units | Lines | Ctns | Units | Lines | Ctns | Total Ctns | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
1 | ABC | 2012-06-17 00:00:00 | 2 | 68523 | [NAME] | 0.3333333333333335 | ML | 0.1666666666666674 | HH | 0.1666666666666661 | 0.666666666666667 | 40 | 6 | 1 | 246 | 14 | 44 | 45 | 2
3 | GHI | 2012-06-18 00:00:00 | 1 | 456 | [NAME] | 0.1666666666666661 | ML | 0.08333333333333304 | HH | 0.08333333333333437 | 0.3333333333333335 | 2 | 2 | 2 | 10 | 1 | 1 | 3
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 2012-06-23 00:00:00 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0.4999999999999996 |  | 0.2500000000000004 |  | 0.2500000000000004 | 1 | 42 | 8 | 3 | 256 | 15 | 45 | 48
Goal: | Have all information transfer to the WE 6-23-12 tab (with no blank lines) by day.
 | Example: | Each tab should be for 52 stores per day.  Some days will have fewer shipments, but no day should have more than 52 shipments.
 |  | Store 1 was processed on Sunday and was the only order processed on Sunday.
 |  | Stores 2 and 3 were both processed on Monday and were the only orders processed on Monday.
 |  | Store 12 was processed on Tuesday and was the only order processed on Tuesday.
 |  | Stores 18 and 19 were processed on Wednesday and were the only orders processed on Wednesday.
 |  | Store 22 was processed on Thursday and was the only order processed on Thursday.
 |  | No orders were processed on [NAME]. or Sat.
 |  | If no orders were processed then cells should be blank.
 |  | If orders were processed on Sunday then they should be pulled to the WE 6-23-12 tab.  When all orders from Sunday have been transferred to
 |  | the WE 6-23-12 tab, then the orders from Monday should be next, followed by Tuesday, and so on and so on through Saturday.
 |  | I need the above sheet to read as follows based on the information that was entered on the previous tabs:
 |  |  |  |  |  | WEEK ENDING: |  |  |  | 2012-06-23 00:00:00 |  | Over Pack |  |  | Full Case
Store # | Store | Date | Pgs. | Order# | Puller | Total Time | QA | Total Time | Stacker | Total time | Total Time | Units | Lines | Ctns | Units | Lines | Ctns | Total Ctns
1 | ABC | 2012-06-17 00:00:00 | 2 | 68523 | [NAME] | 0.3333333333333335 | ml | 0.1666666666666674 | HH | 0.1666666666666661 | 0.666666666666667 | 40 | 6 | 1 | 246 | 14 | 44 | 45
2 | DEF | 2012-06-18 00:00:00 | 5 | 123 | jc | 0.2499999999999991 | ml | 0.1666666666666661 | hh | 0.2499999999999991 | 0.6666666666666643 | 41 | 13 | 25 | 2 | 15 | 2 | 27
3 | GHI | 2012-06-18 00:00:00 | 1 | 456 | [NAME] | 0.1666666666666661 | ML | 0.08333333333333304 | HH | 0.08333333333333437 | 0.3333333333333335 | 2 | 2 | 2 | 10 | 1 | 1 | 3
12 | DAVE | 2012-06-19 00:00:00 | 5 | 965482 | Justin | 0.9999999999999991 | Tonya | 0.4166666666666679 | [NAME] | 0.5000000000000009 | 1.916666666666668 | 149 | 8 | 2 | 264 | 17 | 51 | 53
18 | MICKEY | 2012-06-20 00:00:00 | 3 | 6854759 | [NAME] | 0.4166666666666665 | ML | 0.1666666666666661 | HH | 0.2500000000000004 | 0.833333333333333 | 157 | 11 | 1 | 295 | 24 | 64 | 65
19 | MINNIE | 2012-06-20 00:00:00 | 2 | 63241458 | [NAME] | 0.1666666666666661 | ML | 0.08333333333333304 | HH | 0.08333333333333437 | 0.3333333333333335 | 2 | 2 | 2 | 10 | 1 | 1 | 3
22 | LOUIE | 2012-06-21 00:00:00 | 4 | 689 | WM | 0.1666666666666661 | TH | 0.08333333333333304 | HH | 0.2500000000000004 | 0.4999999999999996 | 45 | 3 | 1 | 134 | 10 | 33 | 34
 |  |  |  |  |  | 2.499999999999996 |  | 1.166666666666667 |  | 1.583333333333336 | 5.25 | 436 | 45 | 34 | 961 | 82 | 196 | 230