Copying the same columns from multiple sheets into a new one

Hello.

I have a workbook with many sheets, each with many columns used and I already have a load of code to get that down to 4 columns per sheet.
Now what I need to do is to open a new sheet and copy all of the data from all 4 column of all of the sheets so I have 4 very long columns on one sheet.

I've been trying to make this work, but Excel doesn't like it because the copy and paste ranges are different, but nothing I do seems to help!
I thought I could specify 200 rows as I'll never have more than that on the source sheets, but then Excel thinks that the next blank row is 201!

Please Login or Register  to view this content.

Any help would be greatly appreciated.