Transfer of data from worksheets to a summary worksheet

I am trying to create a workbook where the values on worksheets 2 upwards are summarised on the first sheet eg
value in sheet 2 cell $G$3 needs to be moved to Sheet 1 cell H2
value in worksheet 3 cell$ G$3 to sheet 1 cell H3
value in worksheet 4 cell$ G$3 to sheet 1 cell H4
value in worksheet 5 cell$ G$3 to sheet 1 cell H5
value in worksheet 6 cell$ G$3 to sheet 1 cell H6
value in worksheet 7 cell$ G$3 to sheet 1 cell H7

I need to find a simple formula for doing this without having to type in every formula separately.

Originally Posted by pwholmes

I am trying to create a workbook where the values on worksheets 2 upwards are summarised on the first sheet eg
value in sheet 2 cell $G$3 needs to be moved to Sheet 1 cell H2
value in worksheet 3 cell$ G$3 to sheet 1 cell H3
value in worksheet 4 cell$ G$3 to sheet 1 cell H4
value in worksheet 5 cell$ G$3 to sheet 1 cell H5
value in worksheet 6 cell$ G$3 to sheet 1 cell H6
value in worksheet 7 cell$ G$3 to sheet 1 cell H7

I need to find a simple formula for doing this without having to type in every formula separately.

Try

=INDIRECT("Sheet"&ROW()&"!"&"G3")

It will need modifying if your sheets are not named Sheet2, Sheet3 etc.

HTH