merging documents,exporting long landscape table to word with page breaks & numbers

Hi all,

Time sensitive questions here.

2 big questions:

(1) Can I merge a group of word and excel documents someshow so they print together with continuous page numbering and formatting and with a common table of contents? i.e. can I make a word doc with some magic code in it that automatically pulls them all together?

(2) Can I force the page numbers on a printed excel document to go where they don't seem to want to? (see below)

Background and details:

I am taking my first stab at using the formatting features in word (i.e. Header styles that allow auto-generation of a table of contents, etc...) as I assemble the chapters, tables, and appendices of my thesis into one large document.

One long appendix (37pp) has to be landscape oriented, but the page numbers still have to go along the short edge of the page (portrait oriented) as they do in the rest of the book. I have used the "repeat rows at top of page" option in page setup to keep my headers consistent throughout the document. I don't want to do the tedious copy and "past special" method for such a long appendix, as it will inevitably need to be modified in future drafts.

I'd like to keep chapters 1-3(.doc) and appendices 1 and 2(.xls) as separate files that I can modify but have some repeatable means of pulling them all together as described above without just copying and pasting them into one word doc, as that seems to make trouble with the word styles and formatting, I can't just past a 37 page table sideways into word, and the combined document is just too long to deal with.

That was long, I know, but I'd appreciate any advice offered with this as I'm coming down to the wire here!!
Thanks!