I have a workbook with 10 worksheets.
I want to create the 11th sheet as a summary sheet.

So on the 11th sheet I would like to have column A, row 1 = column A, row 1
of the first worksheet

I would like the column to be fixed, the row to be fixed but the worksheet
to change automatically.

Is there a way to do this without entering each formula individually?