I really need to be able to refer to sheets with variable sheet names.
I managed to get this working within one workbook using the indirect
function. However i need to be able to do this referring from one
workbook to the sheets in another workbook. The indirect function only
works in this case if both workbooks are open which in my case isn't
practical.

Does anyone know anyway of doing this, either by just using excel, or
by using VBA as well? It would be a great help.

Thankyou!

Daisy