I kind of knew that, but I needed to know you weren't using some new math on us.

So you want to grab a column of data from a bunch of worksheets and stick them on the bottom of a single worksheet. I kind of have the idea. Are all these worksheets in different workbooks? As in different .xlsx files or are they all in the same workbook?

To do this problem I need a small sample file. I would turn on the macro recorder and do about 2 of the copy and paste columns by hand. Then I'd look at the Macro code that is recorded to see what Excel VBA thought I'd done. Then I'd find the step that copied "on the bottom" of the column and change this code from a fixed Range to a variable. Test the new code and send it back to you to figure out.

Is that what you want? Can you supply a sample file(s)?