If you select all the workbooks by clicking on the first sheet and then
Shift+Click on the last sheet it will group the worksheets. You can then
type or paste your heading and formulas,format the worksheet and type all
your constants and the changes occur in all selected workbooks.

To ungroup you can either click on an unselected tab, or right click on any
selected tab and select Ungroup.
--
Kevin Backmann


"Big Bad Nige" wrote:

I want to keep the same column headings when I move to a new sheet in Excel,
how do i set it up so the new sheet always has the same titles, without the
need to copy and paste each time ?