How to get the same value always without typing/pasting them

[luria]

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]Header (A1 Sheet 1)
[/TD]
[TD]Header (A1 Sheet 2)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1 A2
[/TD]
[TD]1,2,3,4,A2,A3,A4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2 A3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 A4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]






Hello,
am using an excel macro which transposes the values from sheet 1 to sheet 2 with a comma separating one value from another.
The macro is designed such that the first 1000 values from sheet 1 column A i..e, rows A2 to A1001 get transposed to sheet 2 Row A2
The next thousand values from sheet 1 i.e., A1002 to A2002 get transposed to sheet 2 Row A3 and so on.
Am also using a clear all macro with in the same sheet which clears all the data from sheet 1 and sheet 2.

Am facing one problem now.
I have observed that in sheet 1, the text in A2 to A5 is always,always the same, that we typein manually.
From A6, we paste new data everytime.
But from A2 to A5 on SHEET 1, the values are always the same.
What should I do so that we donot have to input the values in sheet 1 column A, rows A2 to A5 and they automatically populate on to sheet 2 row A2 with first 4 values being these default values followed by the next 996 values.

(In the above example: 1,2,3,4 are the default values) which should always get transposed first before anyother value gets transposed without having the need to manually type them.

Also, I was checking if we can have these sure values in sheet 3 and connect it to sheet 2 instead of doing everything in sheet 1.