User inputs number on sheet 1 and multiple cells (from sheet 2) are shown on sheet 3

[rimshot609]

I would like to enter a number on sheet 1 (A1) and have the data from sheet 2 displayed on sheet 3.

For example. If I enter a 1 in cell A1 on sheet 1. I would like only cell A1 of sheet 2 appear on sheet three.

If I enter a 2 on sheet 1 (A1) I would like cells A1 and A2 appear on sheet three (without the need for filling down).

If I enter a 3 on sheet 1 (A1) I would like cells A1-A3 appear on sheet three without having to manually fill down on sheet 3....and so on.

I have attached a spreadsheet as an example. I have no problem getting the first row to appear on sheet 3 using an IF statement but I'm not sure how to have multiple rows appear with multiple if statements and without having to fill down.

Thanks.

[FDibbins]

Try this...
=INDEX(Sheet2!$A$1:$A$4,Sheet1!A1)

[:) Sixthsense :)]

Copy the below code and do right click on SHEET1 sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Then
    If IsNumeric(Target.Value) Then
        With Sheets("Sheet3")
            If Target.Value Then
                Application.ScreenUpdating = False
                .Range("A:A").ClearContents
                Sheets("Sheet2").Range("A1:A" & Target.Value).Copy .Range("A1")
                Application.ScreenUpdating = True
            End If
        End With
    End If
End If

End Sub

[rimshot609]

Thanks FDibbins for you response but sixthsence's solution did the trick! Wow, that was fast. Thanks so much.