Footers across worksheets
 

I know how to apply footers one time by selecting all worksheets. Is there a
way to have all worksheets act as one document? The page numbers start with
1 again for each worksheet. I'd like them to run 1-50 rather than 1, 1, 1,
1,2,3, 1,2,3,4...

I need to transfer this to a .pdf when I'm finished. Any ideas????