Let me see if I understand what you desire.  Let's presume you have a sheet
named 'Master' where you type in new entries for all 'companies' (global,
island, etc)
As you add new entries on that sheet, you want the entry to be copied to
different sheets (tabs) based on the 'company' name?  And you probably don't
want any gaps in the lists on the other sheets, right?

This is a difficult task because of the multiple entries of the same
'company' entry on the Master sheet along with the distinct possibility that
the other 2 items of information may be duplicated also for the same company.

Would you settle for a macro that would allow you to select any cell in a
row on the Master sheet and copy that row to the appropriate other sheet?  
While you would have to handle entries 'manually' by calling up the macro, at
least you'd be saved the typing or even a cut'n'paste operation for each new
entry on the Master sheet.