Spreadsheet: 153234d1335814914-need-help-consolidating-data-across-multiple-sheets-warehouse-store-order-list-4-30-12
Sheet: Apparel

Ordered | Item | Description | Retail | Heat Level | Category
 | PA030-M | "I Aint Afraid Of No Ghost" T-shirt (Black) Medium | 19.95 | N/A | Apparel
 | PA030-L | "I Aint Afraid Of No Ghost" T-shirt(Black) Large | 19.95 | N/A | Apparel
 | PA030-XL | "I Aint Afraid Of No Ghost" T-shirt-(Black) XL | 19.95 | N/A | Apparel
 | PA030-XXL | "I Aint Afraid Of No Ghost" T-shirt-(Black) XXL | 19.95 | N/A | Apparel
 | PA030-XXXL | "I Aint Afraid Of No Ghost" T-shirt-(Black) XXXL | 19.95 | N/A | Apparel
 | PA030-S | "I Aint:Afraid Of No Ghost" T-shirt(Black) Small | 19.95 | N/A | Apparel
 | PA185-L | Burning Sensation T-Shirt  Red (Large) | 19.95 | N/A | Apparel
 | PA185-M | Burning sensation T-Shirt  Red (Medium) | 19.95 | N/A | Apparel
 | PA185-S | Burning Sensation T-Shirt  Red (Small) | 19.95 | N/A | Apparel
 | PA185-XL | Burning Sensation T-Shirt  Red (XL) | 19.95 | N/A | Apparel
 | PA185-XXL | Burning sensation T-Shirt  Red (XXL) | 19.95 | N/A | Apparel
 | PA185-XXXL | Burning Sensation T-Shirt  Red (XXXL) | 19.95 | N/A | Apparel
 | [NAME] | Chilihead t Shirt (Black) LG | 19.95 | N/A | Apparel
 | PA170-Med | Chilihead t Shirt (Black) Med | 19.95 | N/A | Apparel
 | PA170-S | Chilihead t Shirt (Black) Small | 19.95 | N/A | Apparel
 | PA170-XLG | Chilihead t Shirt (Black) XL | 19.95 | N/A | Apparel
 | PA170-XXLG | Chilihead t Shirt (Black) XXL | 19.95 | N/A | Apparel
 | PA170-XXXLG | Chilihead t Shirt (Black) XXXL | 19.95 | N/A | Apparel
 | PA175-L | In Need of Fire Break Glass T-Shirt Red (Large) | 19.95 | N/A | Apparel
 | PA175-M | In Need of Fire Break Glass T-Shirt Red (Med) | 19.95 | N/A | Apparel
 | PA175-S | In Need of Fire Break Glass T-Shirt Red (Sm) | 19.95 | N/A | Apparel
 | PA175-XL | In Need of Fire Break Glass T-Shirt Red (XL) | 19.95 | N/A | Apparel
 | PA175-XXL | In Need of Fire Break Glass T-Shirt Red (XXL) | 19.95 | N/A | Apparel
 | PA175-XXXL | In Need of Fire Break Glass T-Shirt Red (XXXL) | 19.95 | N/A | Apparel
 | PA200-SM | Sm. Hot Chick T- Shirt (Heather Purple) | 19.95 | N/A | Apparel
 | PA200-MED | Med Hot Chick T- Shirt (Heather Purple) | 19.95 | N/A | Apparel
 | PA200-LG | Lg. Hot Chick T-Shirt (Heather Purple) | 19.95 | N/A | Apparel
 | PA200-XLG | X Lg.Hot Chick T- Shirt ( Heather Purple) | 19.95 | N/A | Apparel
 | PA200-XXLG | XX-Lg. Hot Chick T- Shirt ( Heather Purple) | 19.95 | N/A | Apparel
 | PA180-S | Man Running towards fire T-Shirt -  Tee Brown (Small) | 19.95 | N/A | Apparel
 | PA180-XL | Man Running towards fire T-Shirt -  Tee Brown (XL) | 19.95 | N/A | Apparel
 | PA180-XXL | Man Running towards fire T-Shirt -  Tee Brown (XXL) | 19.95 | N/A | Apparel
 | PA180-XXXL | Man Running towards fire T-Shirt -  Tee Brown (XXXL) | 19.95 | N/A | Apparel
 | PA180-L | Man Running towards fire T-Shirt - Tee Brown (LG) | 19.95 | N/A | Apparel
 | PA180-M | Man Running towards fire T-Shirt Tee Brown (Med) | 19.95 | N/A | Apparel
 | PA035-L | Offset [NAME] T-shirt-  Lg | 19.95 | N/A | Apparel
 | PA035-M | Offset [NAME] T-shirt-  Med | 19.95 | N/A | Apparel
 | PA035-S | Offset [NAME] T-shirt-  Small | 19.95 | N/A | Apparel
 | PA035-XL | Offset [NAME] T-shirt-  XL | 19.95 | N/A | Apparel
 | PA035-XXL | Offset [NAME] T-shirt-  XXL | 19.95 | N/A | Apparel
 | PA035-XXXL | Offset [NAME] T-shirt-  XXXL | 19.95 | N/A | Apparel
 | J243 | P.P. Striped [NAME] | 19.95 | N/A | Apparel
 | T310 | Pepper Palace Embroidered Polo - L (Assorted Colors) | 29.95 | N/A | Apparel
 | T35 | Pepper Palace Embroidered Polo - M (Assorted Colors) | 29.95 | N/A | Apparel
 | T315 | Pepper Palace Embroidered Polo - XL (Assorted Colors) | 29.95 | N/A | Apparel
 | T320 | Pepper Palace Embroidered Polo - XXL (Assorted Colors) | 29.95 | N/A | Apparel
 | J239 | Pepper Palace Hat (Black)  [NAME] in center. | 19.95 | N/A | Apparel
 | J241 | Pepper Palace Hat (black) [NAME] w Flames | 19.95 | N/A | Apparel
 | PA020-L | Pepper Palace HOT (Gothic) - Red - L | 19.95 | N/A | Apparel
 | PA020-M | Pepper Palace HOT (Gothic) - Red - M | 19.95 | N/A | Apparel
 | PA020-S | Pepper Palace HOT (Gothic) - Red - Small | 19.95 | N/A | Apparel
 | PA020-XL | Pepper Palace HOT (Gothic) - Red - XL | 19.95 | N/A | Apparel
 | PA020-XXL | Pepper Palace HOT (Gothic) - Red - XXL | 19.95 | N/A | Apparel
 | PA020-XXXL | Pepper Palace HOT (Gothic) - Red - XXXL | 19.95 | N/A | Apparel
 | WS3020 | PETA SHIRTS :TREE [NAME]. (RED) | 19.95 | N/A | Apparel
 | WS3010 | PETA SHIRTS :TREE HUGGER Med. (RED) | 19.95 | N/A | Apparel
 | WS3000 | PETA SHIRTS :TREE [NAME].  (RED) | 19.95 | N/A | Apparel
 | WS3030 | PETA SHIRTS :TREE [NAME]. (RED) | 19.95 | N/A | Apparel
 | WS3040 | PETA SHIRTS :TREE [NAME]. (RED) | 19.95 | N/A | Apparel
 | WS3050 | PETA SHIRTS :TREE HUGGER XXX Lg. (RED) | 19.95 | N/A | Apparel
 | WS3520 | PETA SHIRTS EAT MEAT (BROWN) Lg. | 19.95 | N/A | Apparel
 | WS3510 | PETA SHIRTS EAT MEAT (BROWN) Med | 19.95 | N/A | Apparel
 | WS3500 | PETA SHIRTS EAT MEAT (BROWN) Sm. | 19.95 | N/A | Apparel
 | WS3530 | PETA SHIRTS EAT MEAT (BROWN) X Lg. | 19.95 | N/A | Apparel
 | WS3550 | PETA SHIRTS EAT MEAT (BROWN) XXX-Lg. | 19.95 | N/A | Apparel
 | WS3540 | PETA SHIRTS EAT MEAT (BROWN)..XX-Lg. | 19.95 | N/A | Apparel
 | WS3120 | PETA SHIRTS HOOD ORNAMENT (CHARCOAL) Lg. | 19.95 | N/A | Apparel
 | WS3110 | PETA SHIRTS HOOD ORNAMENT (CHARCOAL) Med. | 19.95 | N/A | Apparel
 | WS3100 | PETA SHIRTS HOOD ORNAMENT (CHARCOAL) Sm. | 19.95 | N/A | Apparel
 | WS3130 | PETA SHIRTS HOOD ORNAMENT (CHARCOAL) X Lg. | 19.95 | N/A | Apparel
 | WS3140 | PETA SHIRTS HOOD ORNAMENT (CHARCOAL) XX Lg. | 19.95 | N/A | Apparel
 | WS3150 | PETA SHIRTS HOOD ORNAMENT (CHARCOAL) XXX Lg. | 19.95 | N/A | Apparel
 | WS3220 | PETA SHIRTS MASHED POTATOES (NAVY) Lg. | 19.95 | N/A | Apparel
 | WS3210 | PETA SHIRTS MASHED POTATOES (NAVY) Med. | 19.95 | N/A | Apparel
 | WS3200 | PETA SHIRTS MASHED POTATOES (NAVY) Sm. | 19.95 | N/A | Apparel
 | WS3230 | PETA SHIRTS MASHED POTATOES (NAVY) X Lg. | 19.95 | N/A | Apparel
 | WS3240 | PETA SHIRTS MASHED POTATOES (NAVY) XX Lg. | 19.95 | N/A | Apparel
 | WS3250 | PETA SHIRTS MASHED POTATOES (NAVY) [NAME]. | 19.95 | N/A | Apparel
 | WS3320 | PETA SHIRTS VEGETARIAN (BLACK) Lg. | 19.95 | N/A | Apparel
 | WS3310 | PETA SHIRTS VEGETARIAN (BLACK) Med. | 19.95 | N/A | Apparel
 | WS3300 | PETA SHIRTS VEGETARIAN (BLACK) Sm. | 19.95 | N/A | Apparel
 | WS3330 | PETA SHIRTS VEGETARIAN (BLACK) X Lg. | 19.95 | N/A | Apparel
 | WS3340 | PETA SHIRTS VEGETARIAN (BLACK) XX Lg. | 19.95 | N/A | Apparel
 | WS3350 | PETA SHIRTS VEGETARIAN (BLACK) XXX Lg. | 19.95 | N/A | Apparel
 | WS3420 | PETA SHIRTS WHOLE CAT (GREY) Lg. | 19.95 | N/A | Apparel
 | WS3410 | PETA SHIRTS WHOLE CAT (GREY) Med. | 19.95 | N/A | Apparel
 | WS3400 | PETA SHIRTS WHOLE CAT (GREY) Sm. | 19.95 | N/A | Apparel
 | WS3430 | PETA SHIRTS WHOLE CAT (GREY) X Lg. | 19.95 | N/A | Apparel
 | WS3440 | PETA SHIRTS WHOLE CAT (GREY) XX Lg. | 19.95 | N/A | Apparel
 | WS3450 | PETA SHIRTS WHOLE CAT (GREY) XXX Lg. | 19.95 | N/A | Apparel
 | PA195-LG | Practice Safe Eating - T Shirt (Navy) LG | 19.95 | N/A | Apparel
 | PA195-MED | Practice Safe Eating - T Shirt (Navy) Med | 19.95 | N/A | Apparel
 | PA195-SM | Practice Safe Eating - T Shirt (Navy) Sm | 19.95 | N/A | Apparel
 | PA195-XLG | Practice Safe Eating - T Shirt (Navy) XL | 19.95 | N/A | Apparel
 | PA195-XXLG | Practice Safe Eating - T Shirt (Navy) XXL | 19.95 | N/A | Apparel
 | PA195-XXXLG | Practice Safe Eating - T Shirt (Navy) XXXL | 19.95 | N/A | Apparel
 | PA105-LG | Property Of Since 1989 - Navy - LG | 19.95 | N/A | Apparel
 | PA105-Med | Property Of Since 1989 - Navy - Med | 19.95 | N/A | Apparel
 | PA105-SM | Property Of Since 1989 - Navy - Small | 19.95 | N/A | Apparel
 | PA105-XLG | Property Of Since 1989 - Navy - XLG | 19.95 | N/A | Apparel
 | PA105-XXLG | Property Of Since 1989 - Navy - XXL | 19.95 | N/A | Apparel
 | PA105XXXLG | Property Of Since 1989 - Navy - XXXL | 19.95 | N/A | Apparel
 | PA190-LG | Sauce So Hot Cat Shirt (Brown) LG | 19.95 | N/A | Apparel
 | PA190-Med | Sauce So Hot Cat Shirt (Brown) Med | 19.95 | N/A | Apparel
 | PA190-SM | Sauce So Hot Cat Shirt (Brown) Sm | 19.95 | N/A | Apparel
 | PA190-XLG | Sauce So Hot Cat Shirt (Brown) XL | 19.95 | N/A | Apparel
 | PA190-XXLG | Sauce So Hot Cat Shirt (Brown) XXL | 19.95 | N/A | Apparel
 | PA190-XXXL | Sauce So Hot Cat Shirt (Brown) XXXL | 19.95 | N/A | Apparel
 | PA010-L | Wall of Flame Shirt (Black Bustin' Out ) LG | 19.95 | N/A | Apparel
 | PA010-M | Wall of Flame Shirt (Black Bustin' Out ) Med | 19.95 | N/A | Apparel
 | PA010-XL | Wall of Flame Shirt (Black Bustin' Out ) XL | 19.95 | N/A | Apparel
 | PA010-XXL | Wall of Flame Shirt (Black Bustin' Out ) XXL | 19.95 | N/A | Apparel
 | PA010-XXXL | Wall of Flame Shirt (Black Bustin' Out )XXXL | 19.95 | N/A | Apparel
 | PA010-S | Wall of Flame Shirt (Black Bustin Out) Sm. | 19.95 | N/A | Apparel