Hi all,

I'm new here, and have posted this thread into the Excel General section as I am not sure which section would best fit what I am trying to achieve.

I have an Excel workbook Master that I want create new, constantly updating/refreshing series of workbooks from. The Master data sheet changes monthly as new student lines are added, so the data source would be changing regularly.

There are over a 100 columns of data and about 200 rows in the Master. I only need about some of the columns in my new workbooks.

An example of one workbook would be that I have the existing four columns taken from the Master:

Student Number | Student Name | Confirmation Date | Supervisor 1 | Supervisor 2 | Comments
1234567 | Joe Smith | 12/12/2018 | Susan Jones | John Doe | XXXXX

When new students get added, I want them to populate underneath the existing data. Additionally, if Joe's confirmation date or supervisors change, I also want that information to refresh from the new Master, whilst retaining any comments I have added about the student.

I hope I've provided enough information. The current tracking system is fully manual which is onerous and unreliable, and I am sure that something like this is possible, but I don't have enough Excel knowledge to make it happen. Any assistance that is provided would be greatly appreciated :-)