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.
Bookmarks