<div>
You can use the INDIRECT function to reference a reference on a sheet with the sheet name. I don't know of any formula that will retrieve the name of the last inserted sheet. <br />
<br />
Can you provide a more detailed example if the help on INDIRECT doesn't lead you to the right solution?<br />
<br />
Thomas
</div>


You can use the INDIRECT function to reference a reference on a sheet with the sheet name. I don't know of any formula that will retrieve the name of the last inserted sheet.

Can you provide a more detailed example if the help on INDIRECT doesn't lead you to the right solution?

Thomas

<div>
@Thomas Nutsch<br />
<br />
To keep you in the loop, this is a follow on from previous question:<br />
<br />
<a href="https://www.experts-exchange.com/questions/28308329/Using-Cell-Reference-as-Worksheet-Name.html?anchorAnswerId=39691173#a39691173" rel="ugc">https://www.experts-exchange.com/questions/28308329/Using-Cell-Reference-as-Worksheet-Name.html?anchorAnswerId=39691173#a39691173</a>
</div>


@Thomas Nutsch

To keep you in the loop, this is a follow on from previous question:

https://www.experts-exchange.com/questions/28308329/Using-Cell-Reference-as-Worksheet-Name.html?anchorAnswerId=39691173#a39691173 [https://www.experts-exchange.com/questions/28308329/Using-Cell-Reference-as-Worksheet-Name.html?anchorAnswerId=39691173#a39691173]

<div>
Rob H,<br />
<br />
works like a charm. thanks for the suggestion.
</div>


Rob H,

works like a charm. thanks for the suggestion.

<div>
<div class="content wysiwyg-content">
I have a summary worksheet in a workbook that will be updating with data from many different worksheets. Each time I add a worksheet I will need to add a cell reference on the summary sheet that will update with the worksheet name, even if I make changes to the worksheet name in the future. Is there a formula that I can use for this?
</div>
</div>


I have a summary worksheet in a workbook that will be updating with data from many different worksheets. Each time I add a worksheet I will need to add a cell reference on the summary sheet that will update with the worksheet name, even if I make changes to the worksheet name in the future. Is there a formula that I can use for this?

Update Cell References with New Sheet Names

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.