This video tutorial will show you how to combine data from separate worksheets, spreadsheets, or workbooks(excel files). This tutorial uses the consolidate feature within excel and teaches you how to make one data sheet that will automatically update when data on other spreadsheets is updated; the original worksheet will have links to the worksheets from where the data is pulled. Additionally, you will also learn how to combine data from separate worksheets while preventing the data from automatically updating.