Worksheet with Schedule Updating Worksheet with Standings

[clarkerots]

I have a worksheet that lists a baseball schedule. I'm trying to find a way where I can enter W or L (win/loss) in a column on the schedule and it will update another worksheet with the total W/L record. Ultimately I would like to have a pivot table that sorts the records from first place to last place. This is probably very basic for anyone with greater Excel knowledge than I. Any help is appreciated.

 

[RasGhul]

Can you post some sample data?

 

[clarkerots]

Can you post some sample data?

I tried to attach the worksheet but it didn't work so I'll try to recreate here.

Worksheet 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Baltimore[/TD]
[TD]W[/TD]
[TD]Chicago[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test Data[/TD]
[TD][/TD]
[TD]Test Data[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Baltimore[/TD]
[TD]L[/TD]
[TD]Chicago[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Worksheet 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Baltimore[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Chicago[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'm looking for data entered in B1, D1, B3, and D3 on worksheet 1 to update on worksheet 2. So I enter a W or an L and it updates. Baltimore wins the first game and the W in B1 updates B1 in worksheet 2. They lose the next game, and the L in B3 updates C1 in worksheet 2.