Consolidate data range from multiple workbooks into a separate workbook

Hi,

I have three workbooks (a.xls, b.xls, c.xls), all with a tab named "ja" and of a similar format. I am trying to consolidate the range c3:j12 into a new workbook, in a worksheet called "input" and I will like the data to be dumped in the range b6:i15.

Please help.

Thank you.

Maybe:

Please Login or Register  to view this content.