need help pasting formulas n times in another worksheet

[gsimental]

Good morning VBA gurus!

I need your help with some VBA code to achieve the following:
In Sheet1 I have a list of part numbers from A4 to A292, I need Sheet2 to have 15 rows with the formula =Sheet1!A4 (starting on A4) and so on and so forth (all 288 rows in Sheet1).. so Sheet 2 would look like this

A1 - blank
A2 - blank
A3 - blank
A4 - =Sheet1!A4
A18 - =Sheet1!A4
A19 - =Sheet1!A5
A33 - =Sheet1!A5

etc... can someone please help??

[mehmetcik]

The quick answer is no.

How can anyone help you with this?

You want 15 rows for each part number in sheet 1 and only show us 7.

[gsimental]

Sorry for the confusion, I thought I had that covered by the "so on and so forth" part.
Basically this is what my Sheet1 looks like:

Cell Value
A1 (blank)
A2 (blank)
A3 (blank)
A4 6000-6001
A5 6005-6001S
A6 6010-6001
.
.
.
A292 6500-6001S

snd this is what I need my Sheet2 to look like:

Cell Formula
A1 (blank)
A2 (blank)
A3 (blank)
A4 =Sheet1!A4
A5 =Sheet1!A4
A6 =Sheet1!A4
A7 =Sheet1!A4
A8 =Sheet1!A4
A9 =Sheet1!A4
A10 =Sheet1!A4
A11 =Sheet1!A4
A12 =Sheet1!A4
A13 =Sheet1!A4
A14 =Sheet1!A4
A15 =Sheet1!A4
A16 =Sheet1!A4
A17 =Sheet1!A4
A18 =Sheet1!A4
A19 =Sheet1!A5
A20 =Sheet1!A5

and so on.. that is, for each cell in column A of Sheet1 to have 15 rows in column A of Sheet2 (formula, not paste values)

I hope this is clearer, thank you in advance for any help given