Hello All, I would like to be able to return the value of cell A4 for a number of different sheets in my main sheet "Sheet 1".

I would like this done in individual cells.

So in my main sheet (Sheet 1), cell A1 would return the value of cell A4 from sheet 2. In Cell A2 it would return the value of cell A4 from sheet 3.
Cell A3it would return the value of cell A4 from sheet 4.
Cell A4 it would return the value of cell A4 from sheet 5.

The problem is my sheets are not always named Sheet 3, Sheet 4 etc - I just need a way of looking up a value from a specific sheet (I donlt think naming a cell and using this as a reference works).

Please can someone help