Hi Again
A simple way of doing it is starting from the cell E1 type = then press on
the Tab PPTS 2009 and click on the cell you want and press enter.
Voila your formula is done.
HTH
John
"Boyertown Casket" wrote in
message ...
John, Sorry for not responding immediately, I had some personal matters to
resolve.

The first worksheet (tab) in my workbook is PPTS<space2009 while the cell
I
want to copy to other worksheets is E1. According to what you mentioned
below, I placed this formula in the first cell of another worksheet (tab)
where I wanted the information to appear: =PPTS<space2009!E1

It does not work. Perhaps I am doing something incorrect.

"John" wrote:

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the
Tab,
change it to your if they've been changed.
HTH
John