Summary sheet (Vlookup)

Hello,

I have five club register workbooks populated by staff and we now need to keep a "summary" workbook with all the information collated together.
Each of the five can be a variety of row lengths as they are updated daily.
How can i have one summary workbook pulling through the information from all.

Example club workbook.
Club house 1:
Student ID, Student Name, Activity, Date.

It is a literally "copy and paste" of all five workbook sheets but on an updated/daily basis.

Thank you.