OK you're going to need formulae similar to the following:-

In cell D1 of "NEW_RTGS": =[Book1.xls]summary!$D$1
in cell E1 : =[Book1.xls]summary!$E$1
etc
then in cell D2 : =[Book2.xls]summary!$D$1
and so on changing the Book1 and Book2 to the correct workbook name of course.

"davez" wrote:


Hi all, what i am looking to do is as follows -

i have a folder, ""C:\test\", which contains multiple workbooks, each
of which contain multiple worksheets, one of which is named "SUMMARY"

i need to extract data from the worksheet named "SUMMARY" within each
workbook - cells D1 TO I1 - & create & paste to a new worksheet in my
master workbook, "NEW_RTGS", listing the extracted data row by row
starting at cell D1.

thanks for any help provided


--
davez
------------------------------------------------------------------------
davez's Profile: http://www.excelforum.com/member.php...o&userid=16685
View this thread: http://www.excelforum.com/showthread...hreadid=399773