Copy data from an excel tab to another tab live update

Let me see if I understand your question:

You have a sheet (tab) called Team Names;
You have another sheet (tab) called Summary, on the same workbook;
When you enter a name on sheet Team Names, you want to copy that row to the Summary sheet?

jppinto

yes..

What happens when the user deletes an entry on the Team Names?

won't happen..  

On sheet Team Names, the number of columns filled for each name is always the same? How many?

Here is what the data is in Team Names tab

Names                                              Angler ID
Wil Newlin - Steve Bauer              1107-01
David Farrell - Ron Hayne              1107-02
Derek Coon - Don McLain              1107-03
Jamie Waters - Justin Moore               1107-04
Don Tingley - Richard Summers       1107-05
Jim Vanzo - Gary Long                       1107-06
Aaron Ivy - Richard Ivy                       1107-07
Bob Lynch - Bill Berry                      1107-08
Keith Allen - Charlie Allen               1107-09
Billy Caudill - Rob Caudill                       1107-10
Chris Lally - Mike McDonald               1107-11
Kevin Altmeyer - Jeremy McKenzie 1107-12