Excel Navigation and copying

I have an Excel 97 worksheet with about 18 sheets in it. Every month I need to add a row at the bottom of each sheet with data that I have put in another sheet in the workbook.

Each sheet is not the same size so I need to go to the end of the data copy 2 cells and a bunch of formulas and then do the same thing for every sheet in this spreadsheet.

How can I specify “go to the bottom of the sheet” copy 2 cells and then copy formulas from above without actually specifying the range to copy to?