Malcolm,

You need to use VB to do that.

HTH,
Bernie
MS Excel MVP


"Malcolm" wrote in message
...
Can you pull a field from a worksheet that will insert a name on the other
worksheets name Tab? I tried pulling the field from worksheet 1 by using the
following: =Template!F4