Dear All,
I have about 21 files likes 1,2,3,4 as attached - in these workbooks, have many sheets but will have one sheet named "ABC" which is same to all 21 files.
I have another Macro workbooks with many worksheets. I wish to consolidate the above data at "ABC" into only one worksheet named...