I created a multi page spreadsheet and on each page I have the same heading.
On sheet two, three etc. I entered the following in the same cell
='BOY''S BOTTOMS'!D5
So when you put the information in the first sheet it will automatically
fill in on all the other sheets.

This is my problem I did something so that the formula does not show in the
cell on all the other sheets but I forgot what I did. I need to create a
different type of workbook and want to do the same thing hide the formula but
like I said I can not remember. Does anyone have any clues?

Thanks