I am using Office 2010 to make a booklet in Word. I need to import an Excel spreadsheet that contains multiple pages (not sheets) of data. However, when I: copy, paste special, Microsoft Excel Worksheet Object in my Word doc then the data is copied onto one page - even though I have installed page breaks on the spreadsheet. I've tried a lot of the different paste options and I can't figure out how to make it work.

How can I get my spreadsheet to populate more than 1 page on my Word booklet?

Thanks for any suggestions!