Same Worksheet, want to transfer information from one tab to anoth

[David]

Its a little difficult to explain but I am trying to take information from 1
tab and have it appear in another tab after it is typed in.
The first tab has 4 lists on it and each is a different zone. I want to be
able to transfer that information into a consolidated list that has all the
zones on them.
Looks like this.

tab 1(Red)
WO# Reel# AVG STD Length Zone

This tab has 4 of these sets to separate the information into the 4 zones.

Tab 2(AllRed)
Looks exactly the same but only one set and I would like to take the
information in the first tab from all 4 zones and put them into one list. I
apologize that this is vague but this is the best way to describe it.
Basically I want to be able to type the information once and have it transfer
over to the ALL list instead of copy and pasting it. Thank you for time.

 

[David]

Can anyone help me? Experts? If im vague im sorry but this is the best i
could write up. If this even possible any advice would help.

 

[Pete_UK]

Your description is vague, and that probably accounts for the lack of
responses - please try to be more fulsome in your descriptions, and
then if people can make sense of what you write they'll be better able
to advise you.

Pete