combining multiple columns into column on new tab

Hello,

What I am trying to do is relatively simple, but am having trouble working through it.

I am trying to do the following:

1. Sheet1 has several columns which change on a daily basis, in each of those columns there are a dynamic number of rows which also change. For example column A may have 8 rows with data, but column B may have 15 rows and so on. The number of rows and columns change each day.

2. The headers take up the first 3 lines in any given column, so the data I want to copy starts on row 4. I want the macro to go through each column on sheet1 and copy all of the rows starting on row 4 and below until empty. Then I want it to paste that data into one single column on Sheet2 (for example would paste everything in A1). So on sheet2 column A would contain all of the data for x number of columns from sheet1.



Here is a small example

Sheet1:

Col A Col B Col C

1 5 9
2 1 8
3 1 2


Sheet2:


Col A

1
2
3
5
1
1
9
8
2


Any Help is appreciated, thanks!!!

Thank you,

working somewhat well but isnt capturing all of the values, for example one column has 50 rows and it's only grabbing a few

When it pastes on sheet2 it is leaving spaces in btw the sections it is pasting, can I eliminate those? Also can the values be pasted as special?

thanks

works great! thanks, I was spinning my wheels

the only thing is it leaves 3 empty rows after the first section not sure why