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.