In the Wholeweek worksheet figure out what formula to use to determine which employees missed quota on every day they worked. Use filtering to get list of employees who missed quota every day. Copy and paste it from EXCEL into a word document.

i need an answer to the bolded section giving the following information: there are 6 worksheets, monday-saturday. How would I get all of them onto the WholeWeek worksheet?

A B D E F G H K K Last Name First Name Classification Department Sales Hours Worked Base Pay Commission Gross Pay Missed Quota everyday Thursday Friday Saturday HrlyWage&Quotas Whole Week + + B D E F H K L M Last Name First Name Classification Made Quota 0 1 0 0 0 0 0 1 1 D 1 1 1 O 0 1 1 1 0 1 Allbaugh Bibb Blake Bolyard Bourque Cronk Crouse Duarte Dubben Duck Fetchik Fiddes Freeman Harpole Hauch Henning Hornboek Huang Hulsman Jwang Lax Lessert Mallout Mazza McMath Monac Nigel Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Stanton Stephens Stone Vandrey Walker Joshua Robin Barney Pat Elizabeth June Aleta Shawn Pamela Kelee Vearl Rick Jerry Frank Joann Patricia Kent Woody Russell Buyung Rafael Linda Pedro Pamela Olivia Levitica Emmett Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Catrina Lacretia David Yvonne Danny Monday 0 Department Sales Quota for Base Pay Hours Worked Xtra Salo the day Men's 1,315.86 6 $120.00 $1,200.00 $115.86 Men's 0.00 0 $0.00 $0.00 $0.00 Cosmetics 1,318.97 6 $72.00 $1,050.00 $268.97 Housewares 943.17 6 $72.00 $1,050.00 $0.00 Linens 686.57 7 $140.00 $1,400.00 $0.00 Children's 0.00 0 $0.00 $0.00 $0.00 Children's 649.27 8 $84.00 $1,200.00 $0.00 Children's 0.00 0 $0.00 $0.00 $0.00 Cosmetics 556.00 4 $39.00 $500.00 $56.00 Children's 1.798.88 5 $60.00 $875.00 $923.88 Furniture 4,925.96 $84.00 $1,200.00 $3,725.96 Cosmetics 1,900.54 9 $94.50 $1,350.00 $550.54 Housewares 891.19 5 $52.50 $750.00 $141.19 Furniture 0.00 $0.00 $0.00 $0.00 Furniture 1,251.02 4 $39.00 $500.00 $751.02 Cosmetics 1,788.34 7 $73.50 $1,050.00 $738.34 Housewares 2,654.44 8 $160.00 $1,600.00 $1,054.44 Furniture 0.00 0 $0.00 $0.00 $0.00 Children's 474.44 2 $21.00 $300.00 $174.44 Women's 0.00 0 $0.00 $0.00 $0.00 Housewares 3,789.21 8 $84.00 $1,200.00 $2,589.21 Linens 4,114.09 6 $72.00 $1,050.00 $3,064.09 Housewares 1,195.42 4 $38.00 $400.00 $795.42 Furniture 0.00 0 $0.00 $0.00 $0.00 Housewares 1,745.90 2 $19.50 $250.00 $1,495.90 Men's 2,822.50 6 $63.00 $900.00 $1,922.50 Linens 1,398.88 6 $72.00 $1,050.00 $348.88 Women's 0.00 $0.00 $0.00 $0.00 Linens 3,519.79 4 $42.00 $600.00 $2,919.79 Linens 2,810.02 5 $47.50 $500.00 $2,310.02 Furniture 6,768.68 6 $63.00 $900.00 $5,868.68 Children's 1,047.66 5 $100.00 $1,000.00 $47.66 Men's 0.00 0 $0.00 $0.00 $0.00 Linens 0.00 0 $0.00 $0.00 $0.00 Men's 1,532.87 5 $60.00 $875.00 $657.87 Women's 1,486.22 5 $52.50 $750.00 $736.22 Women's 0.00 0 $0.00 $0.00 $0.00 Cosmetics 0.00 0 $0.00 $0.00 $0.00 Women's 2,719.75 6 $72.00 $1,050.00 $1,669.75 Men's 1994 4A S96.00 $1.400.00 S594 4R Wed Thursday Friday Saturday HrlyWage&Quotas AM PT2 S2 S2 AM PT1 S1 PT1 PT2 S2 S1 S1 S1 PT1 PT2 S1 AM PT2 S1 AM S1 S2 PT1 AM PT2 S1 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S1 PT1 AM S2 S2 Tuesday Commission Commission Gross Pay Rate 3.00% $3.48 $123.48 1.00% $0.00 $0.00 2.50% $6.72 $78.72 2.50% $0.00 $72.00 3.00% $0.00 $140.00 1.50% $0.00 $0.00 2.00% $0.00 $84.00 1.50% $0.00 $0.00 1.00% $0.56 $39.56 2.50% $23.10 $83.10 2.00% $74.52 $158.52 2.00% $11.01 $105.51 2.00% $2.82 $55.32 1.50% $0.00 $0.00 1.00% $7.51 $46.51 2.00% $14.77 $88.27 3.00% $31.63 $191.63 1.00% $0.00 $0.00 2.00% $3.49 $24.49 3.00% $0.00 $0.00 2.00% $51.78 $135.78 2.50% $76.60 $143.60 1.50% $11.93 $49.93 3.00% $0.00 $0.00 1.00% $14.96 $34.46 2.00% $38.45 $101.45 2.50% $8.72 $80.72 1.50% $0.00 $0.00 2.00% $58.40 $100.40 1.50% $34.65 $82.15 2.00% $117.37 $180.37 3.00% $1.43 $101.43 1.00% $0.00 $0.00 1.00% $0.00 $0.00 2.50% $16.45 $76.45 2.00% $14.72 $67.22 1.50% $0.00 $0.00 3.00% $0.00 $0.00 2.50% $41.74 $113.74 250% $14 RR $110 RR WholeWeek + 1 1 1 0 1 1 O O O 1 0 1 1 1 1 0 0 1 1 0 0 1 1