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

Ordered | Item | Description | Retail | Heat Level | Category
 | Q254 | [NAME], 5 oz. | 6.95 | 8 | Hot Sauce
 | Q260 | Autumn In the Smokies, 5 oz. | 6.95 | 4 | Hot Sauce
 | Q278 | Bad to the Bone Hot Sauce, 5 oz | 6.95 | 5 | Hot Sauce
 | Q144 | Beach Bum Hot Sauce w/[NAME], 5 oz. | 8.95 | 7 | Hot Sauce
 | Q122 | Beads 4 Boobs Hot Sauce with [NAME], 5oz. | 7.95 | 7 | Hot Sauce
 | Q256 | Bear Ass, 5 oz. | 6.95 | 8 | Hot Sauce
 | Q219A | Black Bear Brew, 5 oz. | 7.95 | 10 | Hot Sauce
 | HH450 | Black Rose Hot Sauce, 10 oz. | 9.95 | 7 | Hot Sauce
 | Q179 | Branson - Banjo Pickin' Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | Q344 | Branson - Hot Sauce, 5oz. | 7.95 | 4 | Hot Sauce
 | Q269 | Branson - Ozark Hillbilly Hot Sauce, 5 oz. W/Green Wax | 8.95 | 5 | Hot Sauce
 | Q265 | Branson - Playing in Branson Hot Sauce, 5 oz. | 6.95 | 4 | Hot Sauce
 | Q218 | Cades Cove, 5 oz. | 6.95 | 8 | Hot Sauce
 | Q153 | [NAME] 5oz. | 6.95 | 4 | Hot Sauce
 | Q144B | Chicago Hot Sauce, 5oz. | 6.95 | 7 | Hot Sauce
 | Q188 | [NAME]/Chicken Key Chain, 5 oz. | 8.95 | 7 | Hot Sauce
 | Q274B | CHI-TOWN Hot Sauce, 5oz. | 7.95 | 5 | Hot Sauce
 | Q230 | [NAME], 5 oz. | 8.95 | 9 | Hot Sauce
 | MM271 | Choot Em Hot Sauce | 7.95 | 6 | Hot Sauce
 | Q226 | Christmas in the Smokies w/Green & Red Wax, 5 oz. | 8.95 | 8 | Hot Sauce
 | Q220E | Da Hot Sauce, 5oz. (w/orange wax).. | 7.95 | 7 | Hot Sauce
 | Q190 | Dr. [NAME] W/Toilet Noise Putty 5 oz. | 8.95 | 7 | Hot Sauce
 | Q220C | Emerald Coast | 8.95 | 7 | Hot Sauce
 | Q266 | Flavor Of New Orleans  H.S. 5 oz. | 7.95 | 4 | Hot Sauce
 | NN316 | Garden Blend [NAME], 10 oz. | 8.95 | 2 | Hot Sauce
 | Q249 | Garlic Fusion Hot Sauce, 5 oz. | 6.95 | 5 | Hot Sauce
 | MM262 | [NAME], 5 oz. | 7.95 | 7 | Hot Sauce
 | MM266 | Gator Death Roll, 5 oz. with [NAME] | 9.95 | 9 | Hot Sauce
 | W320 | [NAME], 10oz. | 7.95 | 5 | Hot Sauce
 | MM256 | Gator Swamp Gas, 5 oz. | 7.95 | 4 | Hot Sauce
 | N243A | Ghost in the Darkness Hot Sauce, 5 oz. | 12.95 | 10 | Hot Sauce
 | Q210 | Ghost Pepper Jolokia Hot Sauce, 5 oz | 14.95 | 10 | Hot Sauce
 | N3105 | Habanero Pineapple [NAME] (Curry) Hot Sauce, 6.8 fl. oz. | 9.95 | 5 | Hot Sauce
 | [NAME] | Heat: Florida, 6 oz. | 5.95 | 3 | Hot Sauce
 | Q21H | Heat: Illinois, 6 oz | 5.95 | 3 | Hot Sauce
 | Q21B | Heat: South Carolina, 6 oz. | 5.95 | 3 | Hot Sauce
 | Q21A | Heat: Tennessee, 6 oz. | 5.95 | 3 | Hot Sauce
 | Q228 | Hellfire w/[NAME], 5 oz. | 8.95 | 9 | Hot Sauce
 | Q276 | Hillbilly Hot Sauce, 5 oz. | 6.95 | 5 | Hot Sauce
 | Q220B | [NAME],  5oz. | 8.95 | 7 | Hot Sauce
 | N185 | Hottest Sauce in the Universe - 2nd Dimension W/Blue Wax | 14.95 | 10+++ | Hot Sauce
 | P1185 | Hottest Sauce in the Universe w/Red Wax, 5 oz. | 14.95 | 10++ | Hot Sauce
 | Q346 | Hottest Sauce in the World w/Mini World Keychain, 5 oz. | 12.95 | 10+ | Hot Sauce
 | Q351 | I got bourban faced Hot Sauce w. Mardi Gras Bracelet, 5oz. | 7.95 | 6 | Hot Sauce
 | Q250 | Jail Bird Hot Sauce w/Mini Cuffs, 5 oz. | 8.95 | 5 | Hot Sauce
 | HH355 | King Chipotle 5oz. ([NAME]) | 9.95 | 4 | Hot Sauce
 | NN125 | [NAME], 5oz. (Orange Wax) | 9.95 | 7 | Hot Sauce
 | NN130 | King Jalapeno, 5oz. (Green Wax) | 9.95 | 5 | Hot Sauce
 | P1180 | King [NAME], 5 oz. | 14.95 | 10 | Hot Sauce
 | Q284 | [NAME], 5 oz. | 6.95 | 2 | Hot Sauce
 | Q136 | Liquid Explosion Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | Q186 | Liquid Storm Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | Q154 | [NAME],  5oz... | 7.95 | 4 | Hot Sauce
 | Q140 | [NAME], 5 oz. | 6.95 | 7 | Hot Sauce
 | [NAME] | Mango Fusion, 5 oz | 6.95 | 4 | Hot Sauce
 | Q134 | [NAME] Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | Q332 | Mr. [NAME] w/Black Wax, 5 oz. | 12.95 | 10 | Hot Sauce
 | Q184 | Myrtle Beach Carolina Sunrise, 5 oz. | 6.95 | 7 | Hot Sauce
 | Q341 | Myrtle Beach Evening Tide Chipotle Hot Sauce, 5 fl. oz. | 7.95 | 4 | Hot Sauce
 | Q262 | Myrtle Beach Fun In The Sun, 5 fl. oz. | 6.95 | 4 | Hot Sauce
 | Q274 | Myrtle Beach Ocean Sands Hot Sauce w/Sea Shell Key Chain, 5 fl. oz. | 6.95 | 5 | Hot Sauce
 | MM291 | [NAME] with Chili Pepper Lucky Charm, 5 oz | 6.95 | 5 | Hot Sauce
 | Q21D | Old Town Trolly Hot Sauce, St.Augustine | 6.95 | 5 | Hot Sauce
 | [NAME] | Orange [NAME] (Curry) Hot Sauce, 6.8 fl. oz. | 9.95 | 4 | Hot Sauce
 | Q247 | [NAME] US 5 oz. | 6.95 | 6 | Hot Sauce
 | Q178 | P.Palace Aieee! Cajun Hot Sauce w/ Cajun in your Pocket Key Chain, 5oz. | 17.95 | 5 | Hot Sauce
 | G263 | Pain is [NAME] | 7.95 |  | Hot Sauce
 | G267 | Pain is [NAME] | 7.95 |  | Hot Sauce
 | G265 | Pain is [NAME] | 7.95 |  | Hot Sauce
 | Q258A | Panama City Beach Oyster Hot Sauce | 6.95 | 4 | Hot Sauce
 | Q351C | Panama City Beach Spring Break Hot Sauce, 5oz. | 7.95 | 6 | Hot Sauce
 | Q216 | [NAME]/Flip Flops key chain, 5 oz. | 9.95 | 10 | Hot Sauce
 | Q122A | PCB Hot Sauce, 5oz. | 7.95 | 7 | Hot Sauce
 | Q268 | PeppARRRRRRg Palace Hot Sauce, 5 oz. | 8.95 | 7 | Hot Sauce
 | M351 | Pepper Palace Cajun Ghost Hot Sauce, 5oz. | 9.95 | 10 | Hot Sauce
 | N243B | Pepper Palace Ghost in the Bayou | 12.95 | 10 | Hot Sauce
 | M263 | Pepper Palace Habanero Mango Hot Sauce in Flask,   6.8oz | 9.95 | 7 | Hot Sauce
 | M265 | Pepper Palace Habanero Mango Medium Hot Sauce in Flask  6.8oz | 9.95 | 2 | Hot Sauce
 | W315 | Pepper Palace Mango Coco-Loco 5oz | 7.95 | 2 | Hot Sauce
 | Q344A | Pepper Palace Mardi Gras Hot Sauce w/ Hair Extension, 5oz. | 9.95 | 4 | Hot Sauce
 | M441 | Pepper Palace Scorpion Stinger Hot Sauce (5 oz.) | 14.95 | 10 | Hot Sauce
 | Q351A | Pepper Palace St. Augustine City Gates 5oz | 6.95 | 6 | Hot Sauce
 | Q147 | Rectal Rampage, 5 oz. | 6.95 | 4 | Hot Sauce
 | Q12 | Sauce Makers Reserve Chipotle & Garlic w/Blue Wax, 12.5 oz. | 12.95 | 7 | Hot Sauce
 | Q18 | Sauce Makers Reserve Hot w/Red Wax, 12.5 oz. | 12.95 | 7 | Hot Sauce
 | Q14 | Sauce Makers Reserve Medium w/[NAME], 12.5 oz | 12.95 | 5 | Hot Sauce
 | Q16 | Sauce Makers Reserve X-Hot w/[NAME], 12.5 oz. | 12.95 | 8 | Hot Sauce
 | [NAME] | Saucemakers [NAME], 12.7 oz (Orange Wax) | 12.95 | 7 | Hot Sauce
 | Q248 | Saucy Wench 5oz. | 6.95 | 6 | Hot Sauce
 | Q214 | Serrano Lime, 5 oz. | 6.95 | 6 | Hot Sauce
 | [NAME] | Sex On The Beach Hot Sauce | 7.95 | 4 | Hot Sauce
 | Q274A | Shell Island with (seashell key chain) | 7.95 | 5 | Hot Sauce
 | Q342 | Smoky Mountain Hot Sauce, 5 oz. | 7.95 | 4 | Hot Sauce
 | Q132 | Smoky Mountain Memories Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | Q148 | Smoky Mountain Postcard Series, 5 oz. | 6.95 | 4 | Hot Sauce
 | Q280 | Southern Peach & Vidalia Onion, 5 oz. | 6.95 | 4 | Hot Sauce
 | Q219B | Southern Redneck, 5 oz. | 7.95 | 10 | Hot Sauce
 | Q258 | St. Augustine - Castillo De San Marcos National Monument Hot Sauce, 5 oz | 6.95 | 4 | Hot Sauce
 | Q180 | St. Augustine - Lighthouse Anastasia Island w/SilverBlue Wax, 5 oz. | 6.95 | 7 | Hot Sauce
 | NN315 | St. Augustine Historic Datil Hot Sauce, 10 oz. | 8.95 | 6 | Hot Sauce
 | Q343 | St. Augustine Sunrise Hot Sauce, 5 oz. | 7.95 | 6 | Hot Sauce
 | Q150 | Sweatin' in the Smokies W/Compass Key Chain, 5 oz. | 8.95 | 4 | Hot Sauce
 | P241 | Texas Hold'em w/Poker chip key chain, 6.8 oz.  PP | 8.95 | 6 | Hot Sauce
 | HH356 | TG's [NAME], 5 oz. | 7.95 | 5 | Hot Sauce
 | NN308 | The Cats Meow, 5 oz. | 9.95 | 10 | Hot Sauce
 | [NAME] | The Magnificent Mile Hot Sauce, 5oz | 7.95 | 6 | Hot Sauce
 | Q227 | Tidal Wave, 5 oz. | 8.95 |  | Hot Sauce
 | Q182 | Treasure Map Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | P385 | Tropic Escape - Mango Cucumber Hot Sauce,  6.8 oz. | 9.95 | 3 | Hot Sauce
 | P390 | Tropic Escape - Mango Mustard Hot Sauce, 6.8 oz. | 9.95 | 7 | Hot Sauce
 | N3110 | Tropic Escape - Mango Scotch Bonnet Hot Sauce, 6.8 oz. | 9.95 | 7 | Hot Sauce
 | P380 | Tropic Escape - Papaya Scotch Bonnet Hot Sauce, 6.8 oz. | 9.95 | 7 | Hot Sauce
 | P395 | [NAME] Stye Siracha Hot Sauce, 5 oz. | 7.95 | 5 | Hot Sauce
 | Q21E | Turkey Creek Public Market Hot Sauce | 5.95 | 3 | Hot Sauce
 | Q282 | Vidalia Onion & Orange, 5 oz. | 6.95 | 3 | Hot Sauce
 | Q267 | VooDoo Hot Sauce, with mini [NAME], 5oz | 9.95 | 6 | Hot Sauce
 | MM249 | Who Dat Hot Sauce w/gold shrink band | 8.95 | 4 | Hot Sauce
 | Q344C | Windy City Hot Sauce, 5oz. (w/blue wax) | 7.95 | 4 | Hot Sauce
 | Q270 | Winter in the Smokies w/Blue-Silver wax, 5 oz. | 8.95 | 5 | Hot Sauce
 | MM255 | 1st Degree Burn Hot Sauce, 5 oz.** | 6.95 | 4 | Hot Sauce
 | MM260 | 2nd Degree Burn Hot Sauce, 5 oz.** | 6.95 | 7 | Hot Sauce
 | MM265 | 3rd Degree Burn Hot Sauce, 5 oz.** | 6.95 | 8 | Hot Sauce
 | MM269 | 777 Winner Slot Machine Hot Sauce, 5 oz.** | 6.95 | 6 | Hot Sauce
 | MM276 | Air Force Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | P231 | Area 52 Hot Sauce - That sauce that does exist, 6.8 oz.** | 7.95 | 8 | Hot Sauce
 | MM275 | Army Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | Q139 | Ass Whoopin' Redneck Hot Sauce, 5 oz. | 6.95 | 7 | Hot Sauce
 | HH353 | Backdraft (Fire & Rescue) Chipotle, 5 oz.** | 6.95 | 4 | Hot Sauce
 | P396 | Battalion Chief Hot Sauce, 5 oz. | 7.95 | 4 | Hot Sauce
 | Q152 | Big Rack Hunters Hot Sauce, 5 oz.** | 6.95 | 4 | Hot Sauce
 | MM285 | [NAME] with black jacket [NAME], 5 oz.** | 8.95 | 8 | Hot Sauce
 | Q188A | BP - Bringing oil to American shores, 5 oz.** | 6.95 | 7 | Hot Sauce
 | N243 | Burn Your Mouth Hot Sauce ([NAME]), 5 oz. | 12.95 | 10 | Hot Sauce
 | Q126 | Butt Burning Hot Sauce, 5 oz.** | 8.95 | 7 | Hot Sauce
 | MM272 | Coast Guard Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | MM270 | EMT Hot Sauce, 5 oz.** | 6.95 | 6 | Hot Sauce
 | Q264 | Fire Escape Hot Sauce, 5 oz. | 6.95 | 4 | Hot Sauce
 | Q350 | [NAME], 5 oz. | 6.95 | 6 | Hot Sauce
 | Q124 | It's A Boy Hot Sauce, W/Blue Holder, 5 oz. | 7.95 | 6 | Hot Sauce
 | Q123 | It's A Girl Hot Sauce, W/Pink case, 5 oz. | 7.95 | 6 | Hot Sauce
 | MM290 | Jungle Juice, 5 oz.** | 6.95 | 6 | Hot Sauce
 | [NAME] | KOF. We Dare You..(5 oz.) | 6.95 | 6 | Hot Sauce
 | Q217A | KOF. We Double Dare You..5oz | 7.95 | 9 | Hot Sauce
 | NN309 | [NAME] You..(5 oz.) | 8.95 | 10+ | Hot Sauce
 | P237 | Luck be a Lady Hot Sauce, 6.8 oz.** | 8.95 | 6 | Hot Sauce
 | MM273 | Marines Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | MM277 | National Guard Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | MM274 | Navy Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | N3180 | [NAME], 10 oz. (empty bottle)** | 1.99 | 0 | Hot Sauce
 | MM250 | Old Pumper (Fire Engine) Hot Sauce, 5 oz.** | 6.95 | 4 | Hot Sauce
 | P234 | PETA: [NAME] in flask, 6.8 oz** | 8.95 | 7 | Hot Sauce
 | P236 | PETA: Mashed Potato - Green Jalapeno in flask, 6.8 oz** | 8.95 | 5 | Hot Sauce
 | P232 | PETA: [NAME] Orange Habanero in flask, 6.8 oz** | 8.95 | 8 | Hot Sauce
 | P238 | PETA: Vegetarian - Chipotle in flask, 6.8 oz** | 8.95 | 6 | Hot Sauce
 | P240 | PETA: [NAME] in flask, 6.8 oz** | 8.95 | 8 | Hot Sauce
 | MM261 | Playing with Fire Hot Sauce, 5 oz.** | 6.95 | 7 | Hot Sauce
 | MM280 | Police Officer Hot Sauce, 5 oz.** | 6.95 | 5 | Hot Sauce
 | Q138 | Red Rectum Hot Sauce, 5 oz.** | 6.95 | 7 | Hot Sauce
 | Q137 | Squeal Like A Pig Hot Sauce W/Naughty Pig Key Chain, 5 oz.** | 8.95 | 7 | Hot Sauce
 | Q191 | Trailer Trash Hot Sauce, 5 oz.** | 6.95 | 6 | Hot Sauce
 | Q220 | [NAME] (Scandinavian Gold) w/[NAME], 5 oz.** | 8.95 | 7 | Hot Sauce
 | Q272 | [NAME], 5 oz. | 6.95 | 5 | Hot Sauce
 | Q125 | Winning Sauce ([NAME]), 5 oz. | 6.95 | 6 | Hot Sauce