Copy Data from multiple workbook with multiple sheet into single sheet in a single workbook

[czarpogi]

Hi MrExcel,

I am doing a report for my organization to consolidate data from multiple excel files into one report. I need help in combining the data from a multiple workbook with multiple worksheet, and put in is a single sheet in a single workbook. Thanks!

Czar

 

[sijpie]

Re: HELP: Copy Data from multiple workbook with multiple sheet into single sheet in a single workbook

Hi Czar, how is your dataa organised? Are all the sheets similar? Are all the workbooks similar? How is the data you need recognised?

Do you know that Excel 2013/2016/365 has inbuilt consolidation functionality?