how do i set up a 'rolling shift pattern' worksheet?

[Guest]

Using Excel 2003, i want to be able to rotate a list, i.e - columns of
weeks/names/hours to be worked.
i want it to show, for example:-
week 36 and that corresponding name and hours to be worked.
then the following week it show week 37, name and hours, etc. at the top of
the page.

Can this be done automatically by excel or will i still have to keep doing
it manually?