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

--
Message posted from http://www.ExcelForum.com

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)

"u539771 >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm looking to fond a way of having sheet names being shown
> automatically in a fixed range of cells on the front sheet of that
> workbook. The sheet names are not always the same, as they are named
> automatically after a date found in a fixed cell of each sheet, but I
> want these names to be visible on the front sheet once I've hidden the
> sheet tabs.
>
> For example, the document might contain 6 sheets, entitled "Front",
> "22June", "23June", "24June","25June" and "26June". I then want all
> those dates to be shown in cells A16-A20 of "Front" sheet. The dates
> will change regularly and I already have a macro that renames the
> sheets automatically when the data in them is changed, but I want the
> front sheet to update automatically.
>
> Any suggestions please? I've searched through all the tips here and in
> a book of functions, but have drawn a blank.
>
> Thanks
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

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

--
Message posted from http://www.ExcelForum.com