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!