returning results via filter to next sheet

hi gentlemen

im really stuck on how to return data to a second sheet if data selected via a filter.
i have attached spreadsheet i am working on and looking to make this as easy as possible

on sheet "data" cell f2 im looking to return all goals scored by hull
on sheet "data" cell f3 im looking to return all goals conceded by hull

on sheet "data" cell f5 im looking to return all goals scored by hull at home this i will need to do by selecting hull in "home team" filter hull

on sheet "data" cell f6 im looking to return all goals conceded by hull at home this i will need to do by selecting hull in "home team" filter hull

on sheet "data" cell f8 im looking to return hulls last 6 games as over and under which in this example will return the last 6 rows 27-32 and will read 4 under 2 over

on sheet "data" cell f9 im looking to return hulls last 6 games at home as over and under which in this example will return the last 6 rows 22/23/26/27/29/32 and will read 3 under 3 over

if anyone could help i would be really grateful

hi jb
im open to any advice possible i can get through some things but im not the best
i have to admit i have expanded on my original idea so its probably out grown the other one
all help gratefull received

hi jb thats great
how does it pull all the team names together in to column s because if i copy a different teams data in it doesnt pul all the team names

great work so far thanks very much

hi jb
that looks like something i probably can work out
the thing im having trouble with is working out how to return

on sheet "data" cell f8 im looking to return hulls last 6 games as over and under which in this example will return the last 6 rows 27-32 and will read 4 under 2 over

on sheet "data" cell f9 im looking to return hulls last 6 games at home as over and under which in this example will return the last 6 rows 22/23/26/27/29/32 and will read 3 under 3 over

so if i select hull in column b of the home team there will be 15 rows

thanks for your excellent work so far very much appreciated

saved in 2003 format to help
the first sheet over and under is my main sheet and the one i will unltimately be converting

hull is the one i was just working on


kind regards

http://www.sendspace.com/file/cjsy63

is the over and under main file

hi jb and thanks
is there any better way that you can see of laying this out?
i will gladly do it if you see easier ways for this to be done