Excel 2007 : Automatic Consolidation + Fixing Line Positions

Hi,

Suppose I have a workbook such that, aside from the first (master) worksheet, every other ensuing worksheet (in my case, labelled by month) follows the same template (in my case, a table with the same column headings, but unlimited row entries per column for that month). I am wondering whether it is possible to consolidate FUTURE worksheets automatically to the master worksheet by specifying the appropriate column ranges for all future worksheets.

In case the above does not work, I would like to know whether (since I need to create totals for the tables) I may fix a "Totals" line at the bottom of the tables, so that whenever I need to add a new entry, instead of inserting a new line, I may just press down to the next cell below the previous entry and continue with the entries while the "Totals" continues to update.

I have searched many sites for the solution to the first problem but came up with nothing, and as the second is more of a last resort, I have not looked into it yet.

Thank you for your time.

Eric