Paste copied data in rows not columns

I copied the code below to extract data from workbooks in a folder into a "master" workbook sheetfile titled "Summary". It works fine except, I need it to paste the captured data ranges in rows (vertically) instead of columns (side by side). In the "CopyData sub" I tried several times replacing "Col" or "Columns" with "Row" or "Rows, and "xlToLeft" with "either "xlUp" or "xlDown", all with the same 1004 error message, with this row highlighted:

HTML Code: 

Here is the code:

HTML Code: 

Thanks for any help you can give. I think I'm close to a working solution,but I'm stumped .... David

You need to choose the transpose option in the paste special perhaps something like

Please Login or Register  to view this content.

Regards

Dav

Hi Dav, thanks for the quick response. I tried your suggestion but it still comes out with ranges pasted next to each other. Any other thoughts?

I agree that an example would be more helpful and your initial request was about the pasting. I would put some stops in the code, open the local window and step through. It is not entirely clear what you are asking for