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.
"Mo" wrote:

Help Pls.
i want to enter data in the first tab, without retyping them in individual
tabs have the automatic sepeared in other tabs.
exp.
column
a b c a b c
a b c
global 300 pcs 10 boxes global 300 pcs 10 boxes island 400
pcs 20 boxes
island 400 pcs 20 boxes global 200 pcs 5 boxes island 300
pcs 10 boxes
island 300 pcs 10 boxes
global 200 pcs 5 boxes

all vendors global
island

Thank You