Copy values from same location when they change and paste to an extending range

[Smiles80]

Hi there,
This is going to be very difficult to explain in words alone but I will try.

I have a live scores feed into excel. It gives me Sets, Games, Points and the current server at that moment in time. I want to record the point by point history as the match plays out.

Below is the live score feed;

Player	Set	Games	Points	Server
Yafan Wang	0	4	30	FALSE
Junri Namigata	0	2	40	FALSE

<tbody>
</tbody>

And below is how I'd like to record the above data as it changes.

Set		Games		Server	Point By Point
Yafan Wang	Junri Namigata	Yafan Wang	Junri Namigata
0	0	1	0	Yafan Wang	15-0	30-0	30-15	40-15
0	0	1	1	Junri Namigata	15-0	15-15	15-30	30-30	40-30
0	0	2	1	Yafan Wang	0-15	15-15	30-15	40-15	40-30
0	0	3	1	Junri Namigata	0-15	0-30	15-30	15-40
0	0	4	1	Yafan Wang	15-0	30-0	40-0
0	0	4	2	Junri Namigata	0-15	15-15	30-15	30-30	40-30	40-40	Ad-40

<tbody>
</tbody>

It feels like this is possible with VBA but I'm new to it and have only ever made a few adjustments to existing code.

Any help is greatly appreciated and if you happen to live in Sydney I'll treat you to a Schnitzel and Beer!

Thanks