Automatically entering sheet names into a range of cells on one sheet

  • Thread starter Thread starter u539771
  • Start date Start date
U

u539771

I'm looking to fond a way of having sheet names being show
automatically in a fixed range of cells on the front sheet of tha
workbook. The sheet names are not always the same, as they are name
automatically after a date found in a fixed cell of each sheet, but
want these names to be visible on the front sheet once I've hidden th
sheet tabs.

For example, the document might contain 6 sheets, entitled "Front"
"22June", "23June", "24June","25June" and "26June". I then want al
those dates to be shown in cells A16-A20 of "Front" sheet. The date
will change regularly and I already have a macro that renames th
sheets automatically when the data in them is changed, but I want th
front sheet to update automatically.

Any suggestions please? I've searched through all the tips here and i
a book of functions, but have drawn a blank.

Thank
 
Just link to the data cell

A16: =Sheet2!A1
A17: =Sheet3!A1

as the sheet names get updated, the links update

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks Bob. It didn't exactly solve my problem, as the macro that pull
in the data inserts the data as new sheets, and there is therefor
nothing to rename. However, it got me thinking and I've ended u
spending the whole morning changing the way the macro works, in orde
to take advantage of the solution you offered! So thanks again (
think!).

Mar
 
Back
Top