Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to consolidate information from multiple different excel workbooks into one excel workbook. This allows you to add similar information together from many different sources. This video tutorial shows you how to consolidate inventory lists for parts from multiple stores or sections from one company …