Counting last 10 values in a list equal to W or L with updating

I am making a large spreadsheet for the MLB standings. On the main worksheet called "Standings" I have each division with each team listed as well as wins, losses, win pct., games behind, home wins, home losses, away wins, away losses, record in last 10 games, and current streak. There are 30 other worksheets in the file with each teams complete schedule as well as results for each game. Right now, the main worksheet has formulas that auto-update each teams wins, losses, win pct., games behind, home wins, home losses, away wins, and away losses once I enter W or L for each games result. For example: the Detroit Tigers win at home yesterday versus the Minnesota Twins. On the "Detroit Tigers" worksheet, I enter "W" into the "Result" column and the "Standings" worksheet adds one to the "W" column for the tigers, adds one to the "Home W" column for the tigers, and changes their games behind based on the record of the division leader at the time. The file is too large to post, but if anyone would like the file to better see what I am talking about, simply send an e-mail to [email protected]. I have three questions.


1. *Most Important* Is there any formulas or combination of formulas to get cel "K14"on the "Standings" worksheet (picture provided) to lookup the number of cells with the value "W" on each teams individual worksheetfor the last 10 cells that are not empty, but also have it auto-update? For example: right now the formula I am looking for would go to the worksheet named "Detroit Tigers" (picture also provided) and look in I91 to I100, see that there are 5 "W" in this range and return the value "5" to cell K14. However, on 7/17 when there is a value in cell I102, it would look for the value "W" in the new last 10 rows, meaning I92 to I102 (ignore row 101 since it is a one time only scenario) I would also paste the same formula in cell L14 to look up how many "L" there are within the same range, thus giving me a win loss record for the last 10 games.


2. Is there any way to get column A to auto-sort for each division? What I want is to have the worksheet automaticall place the team with the top win pct. on top of the division. For example: pretend that tomorrow, the Red Sox lost and the Rays won. This would make the Red Sox now 0.5 games behind the Rays. When I type in the W on the Rays worksheet and the L on the Red Sox worksheet indicating the result of their repsective games, I want the "Standings" worksheet to automatically notice that column A now says the Rays have the best record in the division and rearrange the teams automatically. I have done an AutoFilter, but I can only enter one in each column.


3. Is there any formula or combination of them to make the"Streak" column on the "Standings" worksheet automated?


I appreciate any help that anyone can give. The second two questions aren't too important, but I really think the first one is possible. Thank you!!