Hi there,

When I reference cell A1 in another worksheet (call it Worksheet1) the formula is

=Worksheet1!A1

I want to be able to include in the above formula a reference to a list which contains the names of different worksheets in the workbook. So when you change the name in the list it changes the worksheet the cell is referencing.........

so say for example cell A1 contains the list and cell A2 contains the formula which references other worksheets in the workbook.

So somehow cell A2 is to be something like =A1!A1 which means = A1!(is the name of the worksheets, which changes when the list is changed)A1(is the cell in the worksheet being referenced)

I hope this all makes sense........

Easty