Help with list

[jcaptchaos2]

I want to be able to have information entered on the main sheet and then automatically transfer to the sheets 1,2,3 etc. I know that I could have each sheet look at the main sheet and then filter it or I could probably us pivot tables. I always seem to learn a better way on this website so I thought I would ask.
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Main Sheet </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">56 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jan </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Chris </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">155 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lisa </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">65 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ben </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">632 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">598 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">45 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">48 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">96 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bruce </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">63 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Matt </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">67 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Terri </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lyn </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">85 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Mike </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bobby </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">512 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">56 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jan </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Chris </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">155 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lisa </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">65 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ben </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Jim </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">632 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bob </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">598 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Al </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">45 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">John </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Red </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">48 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ken </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">96 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bruce </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">63 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Sheet 4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Name </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Color </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Number </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Matt </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Green </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">67 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Terri </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Yellow </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">84 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Lyn </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Purple </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">85 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Mike </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Blue </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8 </font></td></tr>
<tr><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Bobby </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Orange </font></td><td rowspan="1" colspan="1" width="96" height="27" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">512 </font></td></tr>
</table>

 

[Norie]

How automatic do you want this?

 

[jcaptchaos2]

I would like to enter the information in the list on the main sheet and then when you go to the sheet it should be on it's there.

 

[jcaptchaos2]

What do you think Norie?

 

[Norie]

It should be possibly using a worksheet change event, but you would need to work out what change would trigger the code.

For example would it be when a value was entered in the 4th column?

Or would you want to monitor all the columns, then whenever a change was made check if the record is complete and then transfer the data to the appropriate sheet.

 

[jcaptchaos2]

Probably want to monitor all the columns, but I would willing to try anything