Please Help!

I am using VBA in Excel XP with Windows 2000.

I have many spreadsheets (more than 50), some consisting
of several pages each, that are preformatted for LANDSCAPE
printing and need to stay the way they are currently
formatted (by boss).

These formatted pages are to be published and when
printed, need to have a page number placed in the top
right corner, but rotated from landscape to LETTER, so the
finished pages appear like in a book, all paging facing
the same way.

Any ideas for an easy way to accomplish this?

Your example code would be greatly appreciated. Thanks in
advance.