Auto creation of multiple sheets and population of data from one main source (VBA Coding)

Hello!

I've setup a workbook for event registration which, using VLookup, populates 'Sheet 1 columns B-G' from 'Sheet 2 columns B-G' when a unique ID number is entered into 'Sheet 1 column A'. The information it populates is (Applicant Number, Name, Surname, Talk description, Talk time, Group).

What I'm hoping for is that when a unique ID number is entered in Sheet 1 column A, new sheets are automatically created based upon the 'talk description' and populated with the appropriate (Applicant Number, Name, Surname, Talk description, Talk time, Group) information.

I've tried a few methods of VBA coding but all require a manual intervention to run and ideally I was hoping this would be an automatic function.

I've attached a sample file - Any help is greatly appreciated!