Gromit wrote in message ...
Hi

Assuming your list is in column A, type "[workbook.xls]worksheet!" in
cell b1 and =INDIRECT(b$1 & a1) in cell c1.

Then drag down cell c1 to fill in the correct references.

G

Gromit

I see where you're coming from and I've tried it but its returned the
#REF error. Not sure why as the formula seems to be the one I'm
looking for. Any thoughts?

Cheers,
Mike