ExcelBanter - Retrieve Data from closed workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Retrieve Data from closed workbooks - Ron de Bruin (https://www.excelbanter.com/excel-programming/311075-retrieve-data-closed-workbooks-ron-de-bruin.html)

Myriam

Retrieve Data from closed workbooks - Ron de Bruin

I am using Ron's code to retrieve data from closed workbooks.
How can I transpose the output in the destination workbook?

e.g., Data1 Book 1
Data2 Book 2

All times are GMT +1. The time now is 10:33 AM.