Is it possible to have a connected summary sheet to brake down sheets

Bit of background, Ive started a new job with my local council, within 2 weeks Ive become the unofficial IT guy and have remade the workbook we are using to do account reviews for the next few months ( the original they had was a complete mess)
What I really want to do is be able to link my 1 sheet entry's to the other sheets which is going to cut the work load down by weeks.
Im hoping someone can help me out or just tell me its not possible and ill leave it at that.


So let me explain.
I have a work book of 5 sheets, each sheet is laid out the same with the same columns.
each row is an entry for an account, in total looking at about 15000 rows of entries.

I have 1 complete list sheet with all the entries - those process the returned information will be working off this complete list ( team 2)

I have 4 other sheets which brakes this complete list down based on the contact info we have, so 1 has those that we have an email address for , 1 with those with mobile , 1 landline and 1 if we have no contact info.
No entry is duplicated in a brake down sheet if we have more than 1 type of contact information which it goes in is based on priority Email - Mobile - Landline - None ( team 1 are working with these )

What I want to be able to do is link the complete list with the brake down lists. So if a row is altered it will alter the correlating row in the brake down. It would also need to be able to handle adding rows, removing rows or sorting rows by say account number or alphabetically , without it all getting messed up across the sheets.

Am I hoping for to much or is this possible?

I've created a test work book with 100 entries to show, currently its been manually broken down into the other sheets with no links or anything but should visualise what i mean.
Excel 2010 BTW

https://www.dropbox.com/s/t2ds3c0dgr...ting.xlsx?dl=0

What is the purpose of the last 4 sheets? Why does the data need to be split out like that rather than just filtered on the main sheet?
These are questions that would very much dictate which solution is used for this.

BSB

In answer to your question its basically because different people will be working with different sets of the list at the same time and want just specific filtered lists.


Ive managed to link 2 sheets with the following VBA code however im having trouble linking more than 2 sheets if someone knows what i need to alter / add

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
Sheets("Has Email").Range(Target.Address) = Target
End Sub


on has email sheet -

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
Sheets("Full List").Range(Target.Address) = Target
End Sub

Just solved this by creating a loop of linked sheets