Formula for Interconnected Sheets

Hi Every body,
I am trying to drag a formula on Sheet 2 which is related to the only a value from sheet 1 means like =A1 on same sheet. The content is =(sheet1!A1) and after dragging it is showing =(sheet1!B1) =(sheet1!C1) =(sheet1!D1) but my requirement is values like =(sheet1!A2) =(sheet1!A3) =(sheet1!A4)
Is it possible basically i wish to do it horizontly from vertically data
Bovie
India

Try this formula and see if it works for you.

=INDIRECT("Sheet1!"&"A"&COLUMN()+1)