linking filters and copying results

[pink panther]

hi all new to this so please be patient!
what i have is a workbook with 4 worksheets. each is a list of tapes that i use for back ups.
each worksheet has a auto filter so that i can filter by the day i need to use the tape. i.e. when i select monday it displays mondays tapes only.
what i want to do is take the result from this and copy it into another sheet so when i select tuesday it copys onto a 5th sheet in a specific area.
i would also like it to change the day on all sheets filters from a single drop down. i cant put everything on one sheet as there are duplicate tapes and days.
i am tearing my hair out with this and the help file on excel dont help diddly squat! i am using excel 2003.

i hope this is possible or am i asking to much of excel.