IS it possible to use the content of a particular cell as the header/footer?

And if so, HOW!?

Thanks
Alex