VB to copy variable amounts of data and paste to another workbook

I attach a zip file containing a workbook (Debrief.xls) and a sub folder containg two more workbooks.
From the ControlSheet tab of Debrief.xls clicking the purple button activates VB Module (Debrief) which opens all the workbooks in the subfolder and extracts the relevant data and pastes it into the Debrief tab of Debrief.xls.

Thanks to Leith Ross, my problems with the Add Line Buttons in the workbooks in the subfolder have been sorted, but I now need to add as many lines of data as there are from row 26 of the Chronology tab of these workbooks. This will be a variable number of lines. I have manually input the data as the button only imports row 26 at the moment

I also need the button to only open, copy and paste data from new files and input below the last current row.

I have made as much progress as I can, but have not been able to solve these last two problems.

Is this the best method for creating this register?

Any help, as always, very gratefully received