How to number pages sequentially within a workbook when printed

To select a group of worksheets, in this case all of the sheets in the workbook go to the first (left most) sheet in the workbook so it is the active/selected sheet.  Then you can use the excel navigation buttons at the lower left corner of the Excel window to 'scroll' to the far right/last worksheet (the >| button should move you right to it) and hold down the [Shift] key as you select that last sheet.  That will select ALL sheets from the first to the last.

Actually, the easy way is to right-click on any sheet's name tab and choose the "Select All Sheets" option in the list!!  You can search Excel's help for "Select one or multiple worksheets" for more options and methods of choosing sheets.

You can then use File --> Page Setup --> and go to the [Headers/Footers] tab to put the page number into either the header or footer and it will be entered into all sheet's header/footer.  Use the [Custom Header] or [Custom Header] for better control of the setup.

When you get out of the Page Setup dialog, be sure you click on just one other sheet to ungroup the sheets so that any other changes you might make won't be made on all sheets also!

Headers/Footers and set up the page number in either the header or footer section.

The page numbers will do as you wish when the entire workbook is printed.  If you only select one or two or a few pages of it, that group will be numbered beginning with 1 and then sequentially for the group selected.

I have followed what you said above and find that after I have highlighted all the tabs in my workbook (I have 35 tabs), and inserted the page numbers in the footer, and go back to my workbook, there are a multitude of page breaks that were automatically inserted, dividing my pages into multiple pages and increasing my 53 page workbook to 457 pages.  I was unable to manually remove all the page breaks as the cursor was not responding.  It was the big cross symbol instead of the arrow symbol.  What did I do wrong, and how do I compensate for that?

No, I need to know what to do in order to see page numbers when I print out an entire workbook.  I know how to add page numbers to a SINGLE sheet, but then when I choose to print out the entire workbook, I don't see any page numbers on any pages.  I saw JLLatham's response below, but I don't know how to "select" the group.  I'll play in Excel and see what I can find out.

Are you saying you inserted your own page numbers and you want your printer to follow that order?  OR are you asking how to put page numbers on the worksheet?  If the later see...

http://office.microsoft.com/en-us/excel-help/insert-page-numbers-on-worksheets-HA010269060.aspx