Example of consolidating excel workbooks

Alright hey, I want to thank for stopping by, we'll see you next time for another netcast from Mr Excel!I got a call from a friend who wanted to combine multiple Excel files into one Excel workbook.

I remember doing this back in 1995 even, Data, Consolidates!

He had a lot of files in a folder and he wanted to get all the worksheets from all the workbooks into one single workbook.

While this can be done manually, it would be time-consuming and error-prone.

Alright, we're going to use the SUM function, I've never used any of the others, but I guess they're there.

SUM function, the first thing we're going to do is go back to Q1 and point to this range, those four columns, click Add, and then go to Q2, select these columns, click Add, and then Q4, select these columns.