add lines with changing formulas depending on lines in another worksheet

Hi everybody,

I'm new here and currently and Apprentice and trying to make a spreadsheet (in the works) more automated before release.
Basically I have a Spreadsheet called "upload" (within that i have a "upload sheet" and "today" sheet and another called "today"
I have macros in place that will copy the entire "today" sheet out of the "today" workbook and copy it into the "today" sheet within the "upload workbook"
The info is then being pulled from the Today sheet to the Upload sheet e.g. via "=Today!E5" etc
The first sheet only has 5 rows though and my issue is, I want to add the same ammount of lines into the "upload" sheet as there are in the "today".
But at the same time I want to add the formula into the newly added lines, so that if there is 20 lines in "today" it will look between lines 5-XXX, find that after 25 there are no more entries (both start at line 5)
It will thenn add lines on the "upload" with the correct formulas (=Today!E5 to =Today!E25 for this example)
I never went into this kind of depth in Highschool so I am pretty lost, don't even know if it will work,
I would very much appreciate your help

Also note the workbook with only "today" becomes irrelivant after it is pasted into the upload (it is saved with the date as reference) and the upload sheet will only be used to upload to another system and then NOT saved to be used again the day after


P.S. please let me know if I am not being clear or you need any more info/the workbook itself

Just been looking round myself again.
I guess the easiet way would be to select the row below last row in "upload"
Inset line
Fill down
how would I get the macro to look at the last line though?
(note that at the end of the template is a note saying "Tip: This is not the end of the Template. Unprotect the sheet and insert as many rows as needed."
I'd like to keep that as I have a "show lines" in place which will hide all current lines up until "Tip: This is not the end of the Template. Unprotect the sheet and insert as many rows as needed."