automatically copy row into other sheet if cell is equal to

Hello all
this thread started out in Excel- new Users
After a lot of help from NBVC - forum moderator who came up with a solution - thought it still might be best to post it in the programming forum.
His: her questions can be read there
the attachments include test file and solution by NBVC

I'm looking for a solution for my worksheet
i've got a main tab in which appointments are stored they cover about 46 columns (1 row divided in 46 columns = appointment) these rows(apointments) need to be divided amongst other tabs in the same document.
These tabs are the four teams to which the appointments belong.
One of the 46 colums is team ( to which team the appointment should belong) and i want the row copied to the specific tab if the cell is equal to team 1 - team 2 - team3 - team4 and the rows copies itself automatically to the required (team)tab
So each team just has to look at their tab and not scroll through the complete sheet to find their appointments.
Each day new appointments(rows) are added to the main sheet and after manual input of the team names they should be placed in the specific tab underneath the existing rows.
Each team in their turn needs to fill in feedback in their tab - this feedback( a cell ) should be copied unto the main sheet aswell so the secretary has a complete overview and not run through all the tabs.
See the attachment for more info
We're talking about column AG for team and from row 6 down
example:AG6 = team2 then the complete row 6 needs to be copied to tab team2 and so on for the other teams
second need: when information is filled in in team3 AR6 this info needs to be copied autmatically to main AR6 This applies for all info filled in that column not just the cell