Hey,

Can't get my head around something this morning..

I want to link to a cell in a different tab and would like that link to be dynamic.

EXAMPLE

A1
extab
C1
=extab!C1

now if i change A1 to 'extab1' I want C1 to change accordinly to '=extab1!C1'

Ideally I could have a macro that would make a list of all the tabs other than the current one and add them to the current worksheet in the 'A' column.