Send data to multiple sheets

Good afternoon,

I'm new in VBA and what I contructed is with copy past info I've found in several video's.

I want to gather global data from our drivers in a registration sheet.

I'm using a userform to add the data in the registration sheet (still needs work..).

From this data, I want to extract per driver the driving, working and availibilty time and/if he is entiteld to receive a nightshift supplement.

Because I don't known how to automate this, In have first filtered Peter in registration sheet and copied the needed data to "PeterSub) and then used a Vlookup to get the data in PeterCalc.

I guess there's a much easier way to do this.

PS; in the RonnySub sheets I have added 2 jobs on the same day (in yellow).

Is it possible after a Vlookup in RonnyCalc  to add the numbers together?

I only see the first line?

Thanks in advance.

Kind regards,

Marc