Retrieven data from closed workbooks - Ron de Bruin
 

I am using Ron's code to retrieve data from closed workbooks.
The code works wonderful but I need to transpose the output on the
destination book because I am copying a complete column from each workbook
and I want to have the name of the book as the title.
Instead of
e.g. Range1 Book1
Range2 Book2
Range3 Book3
I need it:
Book1................ Book2 ................. Book3
Range1(ColumnC) Range2(ColumnC) Range3(ColumnC) ETC.
Thanks in advance for the help!