collect data easily

Thank you for the help in advance!

I want to collect data from predefined ranges on several sheets.
I collected the ranges to the first column, but since there are a lot (600),
I want to program the date collection.

So, in the first column I have
'Sheet1!'A1:A2
'Sheet2!'A2:A3

Could someone help me with a program, that automatically lists the values of this ranges one by one in one single col?

Manually, I would want to get the values as:
'Sheet1!'A1
'Sheet1!'A2
'Sheet2!'A2
'Sheet2!'A3

Thank you in advance!

Originally Posted by Domski

So it it then Sheet3!A3:A4, Sheet 4!A4:A5 etc?

Dom

okay, a different sample:

first range: Sheet1!A1:B2

This is the way I would do it manually:

Cells(1,1)=Sheet1!A1
Cells(2,1)=Sheet1!A2
Cells(3,1)=Sheet1!B1
Cells(4,1)=Sheet1!B2

The macro should read in the range address,
and then list the values in a column one-by-one automatically.