Football Data

Hi to all


I have an extracted workbook from the football-data website that was already sorted into home teams and away teams with all data for the season 2012-2013 and 2011-2012

I would like help with a macro that will do the following for me:

For each division, the macro sud be able to extarce all data pertaining to a team from the division, for example Arsenal from division E) to be extraced to a ws called Arsenal and the new sheet to contain extracted information from the attached workbook

Next it needs to do some calculations to calculate averages for the first six matches for home and away

I would like a dropdown list that would bring up home against away teams


Say for example Arsenal is going to play against Manchester United

On a table it sud be able to bring up the current six matches for home and six matches for the away


My attached workbook