Split column into multiple columns at predetermined rows

Hello everyone. I hope someone can help. I have two distinct questions that follow from each other. If you can only answer one of them, I would still really appreciate it.

1) Column A has 300,000+ rows of data. The data is from a repeating set of data but the sets are of unequal length. Column B lists the row numbers at which each set ends. Is there any way I can split column A into multiple columns on a new sheet based on the values in column B?

For example.
Column B has the following (the commas represent the next cell down) : 30, 167, 306, 534, 867, 1442, etc. etc.
Is there anyway that I can automatically split column A into a new sheet with column A being rows 1-30, Column B being rows 31-167, Column C being rows 168-306, Column D being rows 307-534, etc?

2) Once I have my new sheet of multiple columns, is there anyway to take each column, and split it into equal columns of x rows each, one on top of the other in a new sheet? Using the above example and a value of 100 for x, Column A of Sheet 2 (rows 1-30) would fill cells A1:A100 (with blanks in rows 31-100) in Sheet 3, then Column B (rows 31-167) would fill cells A101:A200 and B101:B137 in Sheet 3 (because Column B has 137 cells), then Column C would fill cells A201:A300 and B201:240, then Column D would fill A301:A400 and B301:B400 and C301:C328 (because Column D has 228 cells).

I really appreciate any help. Thanks so much!

Holy cow, you are both amazing!!! Thank you so much!!! Patel, thank you so much (I don't need help for the second part, as Buran solved it). Buran, that was particularly incredible! I humbly bow before both your macro skills.

Buran,

One question: The second sheet (problem 2) seems to be duplicating and adding in an extra cell on the last cell for each split?

For example, Column A (first generated sheet) ends off with "boy." Column B (first generated sheet) starts with "girl."
The macro flawlessly splits Column A (from the first sheet) into columns of only 100 rows, and fills cells A1:C100, populating every cell from Column A (from the first sheet).
Column B (from the first sheet) should then start at A101 with "girl." Instead, however, it fills A101 with "boy" (the last value from Column A from the first sheet) and then starts "girl" (i.e. column B from the first sheet) in A102.

Any ideas?

Yes, now it is perfect! Again, thank you so much!!!