Manitain references to internal worksheets

[brad38]

Hello, i have designed a sheet that sources data from about 15 worksheets in the same workbook. I wish to delete these datasheeets and save as a template that i can then reinsert new datasheets using a macro.

My problem is that when i delete the datasheets, the references change from eg. '1BOTTOM'!A:A to #REF!A:A. Can i maintain that link even after deleting the source datasheet?

 

[GlennUK]

Only by using the INDIRECT function, like INDIRECT("'1BOTTOM'!A:A").

 

[brad38]

That is exactly what i needed, thankyou.

 

[GlennUK]

Great!!!