Hi I have some formulas I need to build in Excel which are giving me a lot of headache....

Formula 1:
In B1
=Sheet($A$1)
In B2
=Sheet($B$1)
In B3
=Sheet($C$1)
In B4
=Sheet($A$2)
In B5
=Sheet($B$2)
In B6
=Sheet($C$2)

And so on. This I need to work in a quite big Sheet. Itīs about 30.000 rows so I don't want to do it manually.

Formula 2:
In B1
=Sheet($A$1)
In B2
=Sheet($A$1)
In B3
=Sheet($A$1)
In B4
=Sheet($A$2)
In B2
=Sheet($A$2)
In B3
=Sheet($A$2)

Almost the same as the above. Maybe an easy way to do but i cant figure it out.
Any help would be appreciated.