I've seen 1000 posts on how to base a header on a cell value. I need
to do the opposite. That is to say, if the sheet name is "Dogs", I
need to put that value in a particular cell on a separate sheet. This
can be done with vba or indwelling formula.

Thanks to all.