I am trying to create an excel template which (in theory should save a lot of
work).

I want to create a worksheet (sheet2) containing references to sheet1 which
can be added to any workbook.

I have tried =sheet1!a1 which (as there is no sheet1 until it is imported)
saves as =#ref!.

Hope someone understands and can help.
Thanks.