How to create a input sheet that then allocates to different training courses tabs corresponding to the specific course?

[Waffles255]

Hi There, I want to make a excel sheet that can do the following : I want our sales team to enter all the bookings information on sheet and then create a tab for every course, as they enter the bookings in the input sheet it should allocate the bookings to the specific course tab for example sales enter 20 day online learning course it should allocate all the information entered to the 20 day online learning course tab. I could do it with index match however will index match list all the students? Unless I use a specific booking code however this would entail actually entering the booking number on the 20 day online course tab as well. Is there another way that they could just add it on the one sheet and it would pull through to the 20 day online tab? keep in mind there would be about 50 different types of courses a year.

Thanks in advance

 

[Fluff]

Duplicate How do I make this formula look up the next item and then the third and then fourth etc..

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).