Expanding Worksheet Not Sure if possible

I have a worksheet that has six pages that data can be entered into, on the bottom of the sixth page there are formulas for the total of 4 Columns

My question is

Is there anyway to only have one page which data can be entered into and once this page is full it will add another page. my problem at the moment is that if I only have 1 page with data in it when i print the worksheet it prints the first page and 5 additional blank pages. If this can be done can the total of columns on the last sheet be on the bottom of the number of pages printed.

I hope this makes sense as it is hard to put into words