VBA insert Data program

[knightfall]

I have an excel program where I must enter the name of the winning team in a cell and their score in another cell and the name of the losing team in a cell and their score in yet another cell.</SPAN>
I have the program set to manually calculate. I calculate 3 sheets one at a time. I have recorded a macro that does this for me.</SPAN>
[TABLE="width: 335"]
<TBODY>[TR]
[TD]Enter name </SPAN></SPAN>
[/TD]
[TD]Enter score</SPAN></SPAN>
[/TD]
[TD] Enter name</SPAN></SPAN>
[/TD]
[TD] Enter Score</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]



Once this is done then I move to the next set of teams that I have on another sheet in the workbook. The number of games played can range anywhere of 1 to 50.</SPAN>

[TABLE="width: 335"]
<TBODY>[TR]
[TD]Winner</SPAN></SPAN>
[/TD]
[TD]Score</SPAN></SPAN>
[/TD]
[TD]Loser</SPAN></SPAN>
[/TD]
[TD]Score</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name1</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]Name2</SPAN></SPAN>
[/TD]
[TD]0</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name2</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]Name3</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name3</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]Name4</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name4</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]Name5</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name5</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[TD]Name6</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name6</SPAN></SPAN>
[/TD]
[TD]4</SPAN></SPAN>
[/TD]
[TD]Name7</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name7</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]Name8</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name8</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]Name9</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name9</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]Name1</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Name10</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[TD]Name2</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]



I am in need of a VBA program that would automatically insert and run all the games in the other spread sheet for me.</SPAN>